|
|
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 02:34 PM
by Brad
|
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. ...
|
|
3 |
158 |
|
|
|
|
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...
|
|
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...
|
|
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 01:03 PM
by Eduardo
|
1 |
134 |
|
|
|
|
0 |
155 |
|
|
import address book by
brittany
it it possiable to import out outlook address book into an excel worksheet?
|
|
4 |
165 |
|
|
|
November 9th, 2009 10:07 AM
by Stefi
|
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 09:41 AM
by GENO
|
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 08:33 AM
by LiAD
|
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...
|
|
2 |
198 |
|
|
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...
|
|
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?
|
|
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.
|
|
1 |
130 |
|
|
|
|
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...
|
|
2 |
134 |
|
|
|
|
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 01:13 AM
by FSt1
|
3 |
152 |
|
|
|
November 9th, 2009 12:21 AM
by TomHull
|
0 |
113 |