|
|
|
November 30th, 2009 10:19 AM
by Pete_UK
|
5 |
104 |
|
|
freeze panes cannot be saved by
AndyZZ
Hi there,
I have a big file and in a few sheets I use freeze panes which works fine.
But each time I open the file anew after having saved my changes, the...
|
November 30th, 2009 09:53 AM
by AndyZZ
|
4 |
92 |
|
|
convert text to formula using VLookup by
VickiMc
My question;
I've seen somewhere that you can convert a text string into a formula using
the INDIRECT Function.
What I am constructing is a maintenance...
|
November 30th, 2009 07:51 AM
by VickiMc
|
3 |
83 |
|
|
|
|
3 |
111 |
|
|
Frequency of date by
PAL
I have a list of dates over a two year period (in this example it is over
2006-07; although it will vary given different data sets). I would like to
create...
|
November 30th, 2009 07:28 AM
by T. Valko
|
4 |
109 |
|
|
edit, fill, justify by
Tom
in excel 2003 to justify text in a range of cells, you did edit, fill, justify.
How the hell do you do it in excel 2007?
thanks
--
tom
ps i hate the new...
|
November 30th, 2009 05:11 AM
by Len
|
3 |
119 |
|
|
Linking worksheet and multiple cells by
Greg P[_3_]
Hello All:
Here is my situation. I have 3 worksheets (WS1, WS2, WS3). Column A is
linked to the same Column A in all 3 worksheets. So, if A1= DOG on WS1,...
|
|
1 |
89 |
|
|
Don't Display #N/A by
Dax Arroway
I have a formula that pulls info from another page. The formula is:
{=INDEX('Patient Count'!$J2:$J5000,MATCH(1,('Patient
Count'!$C$2:$C$5000=A2)*('Patient...
|
|
1 |
86 |
|
|
Dealing with blank cells by
Victoria
hi again - I hope it's OK to ask 2 questions on the same day! This problem
is related to the one I posed earlier, but more general.
Let's say a sheet has 3...
|
November 30th, 2009 03:39 AM
by Victoria
|
4 |
90 |
|
|
|
|
1 |
101 |
|
|
How To????? by
Gymclass14 via OfficeKB.com
I am attempting to write a formula in excel 2003. What I am trying to
accomplish is to enter a list of values, say 20, 15, 4, 2.5, 1, 3, 6, 8.878,
17, 20.75,...
|
|
1 |
75 |
|
|
Conditional IF Or Format by
mjones
Hi All,
Can I turn a cell’s contents orange
If G100today() and G101=0
Or
If H100today() and H101=0
Or
If I100today() and I101=0
Or
|
November 29th, 2009 09:40 PM
by mjones
|
6 |
87 |
|
|
|
November 29th, 2009 05:26 PM
by Raj
|
8 |
121 |
|
|
multipule calculations in a single column by
mexmex
Trying to total sum a range of cells in a column and subtract from a total in
another cell in the same column, getting a value error
ex sum cell a10 to a20...
|
|
2 |
88 |
|
|
|
|
2 |
93 |
|
|
Precedent lines by
Sally
How do I save precedent lines in Excel 2007? Everytime I try to save them,
they disappear.
|
|
1 |
91 |
|
|
|
|
0 |
87 |
|
|
|
November 29th, 2009 07:51 AM
by Max
|
1 |
86 |
|
|
match formula needed by
bill gras
in sheet R! A D F in sheet H! A in sheet RC!
H
1 num time price 1 num ...
|
|
2 |
80 |
|
|
|
November 29th, 2009 05:40 AM
by T. Valko
|
4 |
99 |