max function not working for text cells

[pio_proenca]

Dear Excel Forum,
I was trying to use the max function to extract information from a table, however for text cells, that function does not seem to work, please advice.
I am attaching the file for easy reference.

Pio Desousa Proenca
Dubai

[DonkeyOte]

One approach

Please Login or Register  to view this content.

[pio_proenca]

Dear Sir,
Thank you very much
It worked.
Thanks man.

Pio