Named Range issue

[SHUTTEHFACE]

Good morning,

I need some help with a column named range which is showing one cell past what the actual range is. Each of the column in my table have a named range and each is showing the correct range except for this one. I am using the same formula in each column for the named range:

=OFFSET('PSS'!$E$6,1,0,COUNTA('PSS'!$E:$E)-1,1)\

Thanks for the help!

M

[Ron Coderre]

Check the value of the COUNTA function, I suspect it returns one more item than you expected. You can either find the offending cell contents or subtract 2 (instead of 1) from the result.

Another option that I've exploited wherever practical is to convert my data lists to Excel Tables. They automatically expand/contract to accommodate the data AND you can reference their column data by referencing the column heading.

Does that help?

[SHUTTEHFACE]

The counta function is returning the correct number of cells. Converting to excel tables would be a good idea in the long run but i need to figure out what is going on with this in the short term. Any other ideas?

Thanks!

[Ron Coderre]

There are only 5 possibilities:
The start cell of the offset function....E6
The Row Offset...............................1
The Column Offset...........................0
The range height...determined by the COUNTA section
The range width..............................1