LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Doug Mc
 
Posts: n/a
Default Works in all columns but one??

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Put the result of the calculation between 2 columns in a new works Metin Excel Discussion (Misc queries) 3 January 4th 05 11:06 AM
Columns in Excel will not allow user to click in them Kim Excel Discussion (Misc queries) 1 December 28th 04 06:37 PM
Counting the Contents of Two Columns Molochi Excel Discussion (Misc queries) 6 December 22nd 04 08:13 PM
combining 3 columns of same info for a pivot table Julie Excel Worksheet Functions 0 December 15th 04 03:12 PM
interchange columns with rows Herman Excel Discussion (Misc queries) 2 December 8th 04 05:40 PM


All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"