I can't figure out how to make a cell show the last value in a column, when the column gets longer.
If I have a column of arbitrary values in A, and I append more values, how can I make cell D1 always show what the bottom value of column A is ?
I can't figure out how to make a cell show the last value in a column, when the column gets longer.
If I have a column of arbitrary values in A, and I append more values, how can I make cell D1 always show what the bottom value of column A is ?
The bottom value is Text:
=LOOKUP(REPT("z",255),A:A)
The bottom value is Number:
=LOOKUP(10^37,A:A)
Both:
=LOOKUP(2,1/(A1:A65536<>""),A1:A65536)
This should work too...
=INDEX($B$1:$H$1,MATCH(0,B2:H2,-1))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Phuocam -
Man that worked like a champ. thanks.
Since you posted this solution, I have been reading about lookups, and what you did seems to be beyond the 'lookups for beginners'.
If you have time, I have a question :
for Value you use 10^37. That means 10 to the 37th power. that is a big number. Is that some trick that excel uses to select the bottom number in the column ?
How do I mark this SOLVED ?
See my food note (2)
I will do it for you - this time
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks