Let's say all the last name in A2:A100
Create a helper column B
In B2 =Code(A2)
Copy down to B100

In C2 =INDEX(A2:A100,MATCH(MAX(B2:B100),B2:B100,0))


"S" wrote:

Hi,

I wonder if anyone can help me. I've tried to use the max function but it
only seems to work with numbers.

Is it even possible to do what I want to do. I have a list of names and I
want to find Zachary for example as its the last name alphabetically in an
unsorted list of names.

I need to do this in a formula versus sorting.

Any help greatly appreciated.

Thanks

S