This is pulling the first alpha numeric value, is there a way to pull that
last value.

"Max" wrote:

Array-enter in say M1:
=INDEX(L1:L65535,MAX((L1:L65535<"")*ROW(1:65535)) )
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"BAKERSMAN" wrote:
Ok how do you lookup the last alpha numeric value in a column L ?