find furthest cell with number in it.

[anon125]

the spread sheet has many columns with data in them.
some are 4 rows, and some are around 900 or so rows.
they all start at row 8 so i have that
there is a column with column names , like BB, BV etc.
what i need is the second column formulae to go to the column names column and determine the last row of that column.
i still use 2003 version, xls files
how do i do this?
thanks
columns abcd are in the picture. top row is 8

 

[Scott Huish]

=LOOKUP(99^99,INDIRECT(D8&":"&D8),ROW(INDIRECT(D8&":"&D8)))

 

[anon125]

did i do a typo?
thanks

 

[Peter_SSs]

did i do a typo?

Yes

However, I think you only need part of that

=LOOKUP(9^9,INDIRECT(D8&":"&D8))

 

[anon125]

thanks, i will amend it!

 

[anon125]

another typo?
thanks for your patience!
the D column says which columns the dates are in for each one.

 

[Peter_SSs]

another typo?

No, you didn't take note of all my post.

However, I think you only need part of that
=LOOKUP(9^9,INDIRECT(D8&":"&D8))

 

[anon125]

Thank you VERY much Peter.
suggestions on sorting them into some kind of order.
may have to reverse them to suit excel!

 

[Peter_SSs]

Thank you VERY much Peter.

You're welcome.

suggestions on sorting them into some kind of order.
may have to reverse them to suit excel!

I don't know what you mean. What about a small set of sample dummy data with XL2BB so we can test without masses of manual typing and explain, using that sample data, exactly what results you want and where you want them.
(If you have trouble with XL2BB, review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of the XL2BB Instructions page linked above.)

I also suggest that you update your forum profile (click your user name at the top right of the forum, then ‘Account details’) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[anon125]

signature and image updated.
thanks