|
|
|
|
10 |
340 |
|
|
|
|
2 |
281 |
|
|
Time Format Question by
Toria
Hello,
I currently have time entered like this:
173517
90207
I need to look like this:
5:35 p.m.
9:02 a.m.
I've done a ton of research but nothing has worked...
|
|
6 |
139 |
|
|
|
|
5 |
170 |
|
|
Ziping excel 2007? by
excelleration
My company recently upgraded to office 2007. With excel 2003 I could
zip a 30-35mb file to less than 5mb. The same kinds of files/data in
2007 only zip from...
|
|
1 |
116 |
|
|
populate month-yyyy when compare 2 cells by
AskExcel
Dear Forum,
I have a scenario where I need to compare 2 date cells. When cell1 empty
then take cell2 and format the date month-yyyy in cell3. When cell1 not...
|
|
3 |
119 |
|
|
runtime error code 1004 by
Karen
I set up a macro in Excel 2003 but when my associate tries to run the Macro
in 2007 she is getting a run time error 1004.
I noticed in another post it could...
|
|
1 |
138 |
|
|
Zero and Null Sum Function by
Frustrated by Averages[_2_]
I have the following formula in place:
=IF(SUM(I14:N14)1,SUM(I14:N14),"")
The problem I have is when zeros are legitimately entered in the reference
fields...
|
|
3 |
143 |
|
|
Cell Function/Font Color by
HpyTrvlr69
Is there a CELL Function that you can identify the color of a font with?
I would like part of a macro to make a decision based upon the color of the
font in a...
|
|
2 |
122 |
|
|
|
|
2 |
141 |
|
|
|
|
6 |
131 |
|
|
|
May 12th, 2010 07:58 PM
by Bill E
|
0 |
109 |
|
|
IF formula help? by
daisy
Hi, can anyone help me write an IF statement? I have a list of names in
Column A and want to check it against another list of names in Column D - if
the...
|
|
5 |
162 |
|
|
Formula Help by
Danny Boy
VThis formuula below needs some help. We had it working, but want to add in
one piece. If "No Show to MOP" is added on Column T, we want Column U to also
say...
|
|
5 |
109 |
|
|
Worksheet Function required by
Hammer
If I have the following data available based on fuel prices what formula
would I require if I wished to calculate the correct fuel surcharge based on
the...
|
|
2 |
108 |
|
|
VLOOKUP by
Lbengston
Vlookup appears to resolve per the funcion arguements display but does not
return value to the cell on the worksheet.
=VLOOKUP(A2,MAP,3)
MAP is a named range...
|
|
1 |
124 |
|
|
|
|
1 |
100 |
|
|
|
May 12th, 2010 03:10 PM
by LON205
|
0 |
79 |
|
|
|
May 12th, 2010 03:08 PM
by k15y8
|
0 |
97 |
|
|
|
|
6 |
137 |