View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris Chris is offline
external usenet poster
 
Posts: 13
Default Can I find the last value in a column of cells?

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