Can I find the last value in a column of cells?

C

Chris

Hi - I have a column of cells that is fixed length but the entries within it
are not fixed, some columns might have more or less entries than another
column. I want to find the bottom entry in the list, regardless of what row
that entry is in and return the value of that entry please?

eg, all columns have 12 cells, col A has 3 entries, col B has 1, col C has 6
etc. The entries are NOT in value order and cannot be sorted but each column
is independant of the others, if that helps.

TIA
Chris
 
D

Don Guillett

Try this where 99999 is larger than ANY number possible
=INDEX(E:E,MATCH(99999,E:E))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting column width in a table with a macro is not working 0
Extracting a cell value 2
Word macro that can call cells out of Excel for a find and replace 0
Calculate the median value before a specified list 0
LOOKUP VALUE OCCURS >ONCE IN TABLE ARRAY - RETURN LAST OCCURRENCE 6
Avoiding auxiliary cells 0
Copy corresponding cell in Column B if cell in A contains certain text? 1
formula for displaying only the last entry of a group of cells 2

Top