|
|
Concantenate columns with dates and text by
Dazed and Confused
The first two columns in my spreadsheet are dates. The third is text. When
I try to concantenate, the dates turn into numbers.
Any advice would be greatly...
|
|
4 |
217 |
|
|
Counting cells with a calculated value. by
dugasyl
I have been trying without success to do the following in 2007:
Count cells in a named range (Col."H" abt 300 out of 1000 lines containing
data) that are =...
|
|
3 |
151 |
|
|
|
April 3rd, 2009 08:27 PM
by Luke M
|
1 |
173 |
|
|
ABS = and logic functions by
DrPhil
I'm having trouble with this function
=IF(ABS(G30-F30)=0.2,"PASS","FAIL")
If the numbers in G30 and F30 are bigger than 31 it returs false when equal
to...
|
April 3rd, 2009 04:43 PM
by DrPhil
|
5 |
190 |
|
|
|
|
5 |
301 |
|
|
|
|
2 |
232 |
|
|
Copying Macro by
John Calder
Hi
I run Win XP with Excel 2K
I have a worksheet with a pivot table on it. I would like to copy the grand
totals of the pivot table into another...
|
|
2 |
156 |
|
|
|
|
3 |
242 |
|
|
calculate not working by
Janet
I'm having the same problem as Tony. My formulas are suddenly not working.
I've turned calculate auto and manual. tried saving, closing & reopening
file...
|
|
4 |
148 |
|
|
|
|
1 |
235 |
|
|
SORTING by
robo
i have a spreadsheet with 4 columns and multiple rows. the columns are point
number,reading,date and time. how do i set up the columns so i can sort the
data...
|
|
2 |
138 |
|
|
|
April 2nd, 2009 06:05 PM
by Francis
|
12 |
246 |
|
|
|
|
3 |
265 |
|
|
Subforms using same table by
MKuria
Is it possible to create 2 subforms using the same table and how do I link
them? I need one to show fields to populate and one to show cust...
|
April 2nd, 2009 04:04 PM
by MKuria
|
0 |
180 |
|
|
format cells from mm/dd/yyyy to yyyy by
bbane
I am trying to convert the format of a column of cells from mm/dd/yyyy to
yyyy. I used format cells, custom, and yyyy. The cell will change to the yyyy...
|
April 2nd, 2009 03:42 PM
by bbane
|
3 |
136 |
|
|
Color coding dates in excel by
Hilly
Hi ,
I am trying to set upo a spreadsheet to track stock market
purchases,dividends etc.
I have date columns, however I would like to be able to color code...
|
April 2nd, 2009 12:05 PM
by Stefi
|
7 |
212 |
|
|
Formula stopped working by
Tony
I'm having a rather odd problem with my Excel formulas and hope someone can
help me.
Within the week, my Excel spreadsheet formulas have simply stopped...
|
April 2nd, 2009 09:50 AM
by Tony
|
2 |
154 |
|
|
|
|
0 |
106 |
|
|
Updating data from one worksheet to another by
joe2017
I've created an in-depth spreadsheet to organize information. I need to then
take a few columns of that information and put it into a more concise, easier
to...
|
April 2nd, 2009 12:24 AM
by AltaEgo
|
3 |
176 |
|
|
|
|
3 |
127 |