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

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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Chris" wrote in message
...
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

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

Thanks - I don't yet understand why that works but it does!

"Don Guillett" wrote in message
...
Try this where 99999 is larger than ANY number possible
=INDEX(E:E,MATCH(99999,E:E))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Chris" wrote in message
...
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

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

A look in the help index for MATCH and INDEX would help.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Chris" wrote in message
...
Thanks - I don't yet understand why that works but it does!

"Don Guillett" wrote in message
...
Try this where 99999 is larger than ANY number possible
=INDEX(E:E,MATCH(99999,E:E))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Chris" wrote in message
...
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

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

Hi,

Try this

=LOOKUP(9999999,C3:C12)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Don Guillett" wrote in message
...
Try this where 99999 is larger than ANY number possible
=INDEX(E:E,MATCH(99999,E:E))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Chris" wrote in message
...
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