Find last entry in column [SOLVED]

[flywhiz]

Hello.


Is there a formula I can use in a given cell that will evaluate a column I specify and look from top to bottom to return the last (bottom) value in the column? Thanks!

 

[SirJB7]

Hi, flywhiz!

Tried with this?

=BUSCAR("zzzzzz";A:A) -----> in english: =LOOKUP("zzzzzz",A:A)

It just retrieves the last value without looking from top to bottom, is that what you're asking for? If not, please elaborate.

Regards!

 

[flywhiz]

Excellent! Works great! For my information, what do the ZZZZZZ's represent?


And, THANK YOU!

 

[shrivallabha]

Read material in this link:

http://www.mrexcel.com/forum/excel-questions/99621-lookup-value-unsorted-data.html

 

[flywhiz]

Good read. Thanks shrivallabha!

 

[SirJB7]

Hi, flywhiz!

Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted.

Regards!


@shrivallabha

Hi!

Thanks for taking the race baton.

Regards!