Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula problem
I have a big excel file(300m). When I analyse the data on the sheet, say, for
example, give cell D2 the value of C2, then insert a formula =D2+1 for D3, then dragging the D column for the same formula. But the strange thing is that the cells that I thave dragged have the same value, not the sequence with 1 added. however , the formula is always right for each cell but still returns the same value. When i do it one by one by hand, it returns the right answer very odd situation, and hopes for any help Thx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! Formula problem | Excel Discussion (Misc queries) | |||
Problem with formula | Excel Discussion (Misc queries) | |||
Now formula problem | Excel Worksheet Functions | |||
Problem with formula IF(C5="", "",NOW()) | Excel Discussion (Misc queries) | |||
Formula Problem | Excel Discussion (Misc queries) |