|
|
Excel Help Please quick question by
Tom Jacques
i want to have a cell automatically fill its self in when another cell says a
certain thing.
eg - if i type "blue" into D5 i want D6 to automatically change...
|
|
7 |
308 |
|
|
min,average0 if 52 cells read zero by
Mike
I have 52 cells w265 that all read zero until data is entered this means one
cell in each worksheet example Week 1 w265, week 2 w265, week 3 w265 to week
52...
|
|
2 |
230 |
|
|
|
|
3 |
303 |
|
|
Non reciprocal formula? by
Tuk
Hi, can anyone help with this? I need formulae which demonstrate a flow in
one direction. I'll put it a simply as I can.
I want to be able to add manually, a...
|
|
1 |
254 |
|
|
|
|
1 |
405 |
|
|
|
|
1 |
301 |
|
|
|
November 15th, 2009 04:30 PM
by T. Valko
|
3 |
331 |
|
|
|
|
8 |
309 |
|
|
HELP WINDOW PROBLEM by
MrBill
Hi.. when I open help, it seems that it makes my work window collapse so I
cannot fix the problem I am researching.
Since I re-installed office, I cannot...
|
November 15th, 2009 01:54 PM
by MrBill
|
0 |
278 |
|
|
|
November 15th, 2009 12:41 PM
by JLatham
|
1 |
263 |
|
|
Indirect function countif by
puiuluipui
Hi, i have a number in "C5" and i need to search for this number in another
workbook. I need to search only in column C:C.
But i need an indirect function...
( 1 2)
|
|
11 |
486 |
|
|
|
|
1 |
322 |
|
|
|
November 15th, 2009 06:08 AM
by kxxxk
|
0 |
294 |
|
|
|
November 15th, 2009 05:15 AM
by Number2
|
0 |
300 |
|
|
need help in formula by
kyoko
i really need help for this one:
A B C
oct 27 -50 cover
oct 27 -50 not cover
oct 27 50 cover
oct 28 150 cover
oct 28 ...
( 1 2)
|
November 15th, 2009 03:13 AM
by T. Valko
|
10 |
373 |
|
|
Vlookup only the last 6 characters by
JoeP
I have a spreadsheet starting in cell A4. I want to lookup only the last 6
digits in column A and then lookup the value in column J and return the...
|
November 15th, 2009 12:47 AM
by JoeP
|
2 |
218 |
|
|
|
|
1 |
259 |
|
|
VLOOKUP Question by
OverMyHead
I feel stupid but I cant figure out what is wrong with my forumla. It will
only return #N/A.
Here is the...
|
November 14th, 2009 11:18 PM
by Max
|
3 |
212 |
|
|
Superscript in Custom Format by
Emece
I want to do a custom format that includes Km2, with the 2 as a superscript.
First I write it down in a cell and set the 2 to be a superscript. Eventhough
in...
|
|
2 |
257 |
|
|
Indirect by
puiuluipui
Hi, can this code be made to work with more than one sheet?
=IF(SUMPRODUCT(COUNTIF(INDIRECT(""&"LUNI!$C:$C"),C5))0,"YES","NO")
-sheets : LUNI ; MARTI ;...
|
|
2 |
253 |