Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have the following formula in about 15 columns in one row.
=OFFSET($D$1,COUNTA(INDIRECT("$d$1:$d"&ROW()-1))-1,0) The only difference in the other columns is, of course, the Column identifier.. This works fine in all columns except Column E. I've looked and looked and it looks to me like Column E is formatted EXACTLY like all the other columns. Column E contains this: =OFFSET($E$1,COUNTA(INDIRECT("$e$1:$e"&ROW()-1))-1,0) but all I get in Column E is a blank result. Does anybody have any idea what the problem is? Thanks, Doug |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Put the result of the calculation between 2 columns in a new works | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
combining 3 columns of same info for a pivot table | Excel Worksheet Functions | |||
interchange columns with rows | Excel Discussion (Misc queries) |