A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
If and Vlookup Query by Lainyb
I was wondering if anyone can help me create a look-up as I am tearing my hair out trying to get it to work. In main spreadsheet I have a cell N2 with 35.00...
November 9th, 2009 03:34 PM
by Brad Go to last post
6 174
VBA by Brown Recluse[_2_]
Trying to circumvent the conditional format limit of 3 in Excel 03. I have a file with various percents and want to color code each percent threshold. ...
November 9th, 2009 03:10 PM
by Brown Recluse[_2_] Go to last post
3 141
Formula help: Duration Without Weekend Days by JP
Hi, I'd like to compute the duration of a series of tasks by subtracting the end date from the start date--but also removing the weekend days to give an...
November 9th, 2009 02:46 PM
by David Biddulph Go to last post
4 188
web query by NoSpammer
How can I import some stock market price data into excel and update automatically every 15mins? I read the help from MS excel but it seems their example only...
November 9th, 2009 02:44 PM
by Don Guillett Go to last post
1 116
Rows to Col Macro Question by Buyone
Hello, I found and borrowed this macro from Dave Peterson. It works, but i need to add in a couple of things to make my life that one bit easier. I need to...
November 9th, 2009 02:05 PM
by Don Guillett Go to last post
1 160
Conditional Formatting Font Change by Hugh
In Excel 2007 I have applied Conditional Formatting to a range of cells (B1 to B100) so that the font colour changes to green if the corresponding cell in...
November 9th, 2009 02:03 PM
by Eduardo Go to last post
1 134
insert rows automatically to avoid overwriting by Tushar Bhatt
A pivot table that consist of several sales person ID and commission data is surrounded by text above and below (approval block). Each sales person has...
November 9th, 2009 12:41 PM
by Tushar Bhatt Go to last post
0 155
import address book by brittany
it it possiable to import out outlook address book into an excel worksheet?
November 9th, 2009 11:19 AM
by David Biddulph Go to last post
4 165
Looking for assistance for an unusual conditional formatting probl by John C.
There are two tables, say A1 through E5 and A7 through E11. I want to compare A1 to A7 and color the minimum, compare A6 and A16 and color the minimum,...
November 9th, 2009 11:07 AM
by Stefi Go to last post
2 168
Linking docs by GENO
I have linked 3 excel docs which have about 90% similar formatting and formulas. in these docs i have a list of questions which differ slightly and I would...
November 9th, 2009 10:41 AM
by GENO Go to last post
0 145
Impossible? dynamic copy/paste by LiAD
Hi, I have a list of data contained in a series of files stored on a network. There is one file for every month, ( file name Jan, Feb etc). Each file has...
November 9th, 2009 09:33 AM
by LiAD Go to last post
0 131
Calculates field in pivot table by שרון
Hi, I can't find a way to view my calculated field in a pivot table. I just need to see how they were defined (the formulas) because i want to build a new...
November 9th, 2009 07:34 AM
by שרון Go to last post
2 181
Editing cell names by Al
Is there any means of editing a vast number of cell names within a spreadsheet without having to resort to Insert - Name - Define and editing each one...
November 9th, 2009 07:20 AM
by Jacob Skaria Go to last post
1 129
how do I put in a name for the columns? by asdf
I need to put in a name for the columns. But I don't want the names to be part of the data in the columns, just want it to be a name. How do I do that?
November 9th, 2009 07:04 AM
by Ms-Exl-Learner Go to last post
2 107
Find first empty cell in column by TomHull
hi, Dos anyone know if there is a formula method for returning the cell reference of the first cell in a column that is blank? Cheers.
November 9th, 2009 06:16 AM
by Jacob Skaria Go to last post
1 130
How to search for a code, and have the correct information auto fi by Jared
So, here is the basic problem - I have one spreadsheet that has 100's of codes, and information below each code. I have another spreadsheet that’s called a...
November 9th, 2009 06:04 AM
by JLatham[_2_] Go to last post
4 153
Find first empty cell in column by TomHull
Hi, I need a formula that finds the first empty cell at the bottom of a column of data. I have tried using the find and select function in a macro and it...
November 9th, 2009 02:37 AM
by Jacob Skaria Go to last post
2 134
Finding First Empty Cell in a Column by TomHull
Hi, Is there a formula method to find the first empty cell in a column? Thanks, Tom
November 9th, 2009 02:19 AM
by Jacob Skaria Go to last post
5 128
Help with Excel by Owen
I have a spreadsheet with 3 columns - I want to know the number of times col A = texta, and col b = textb and col c = text c. how do I do this in excel?
November 9th, 2009 02:13 AM
by FSt1 Go to last post
3 152
Finding First Empty Cell in a Column by TomHull
Hi, Is there a formula method to find the first empty cell in a column? Thanks, Tom
November 9th, 2009 01:21 AM
by TomHull Go to last post
0 113
Post New Thread


Display Options
Showing threads 10321 to 10340 of 139764
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.