??? Garreth, you lost me. Maybe I'm missing something and you could explain
with sample entries in the VLOOKUP()?

"Garreth Lombard" wrote:

Hi there,

You might want to concider using the vlookup formula combined with the max
in this one.

=VLOOKUP(MAX(range, range_including_answer_col, col_ref,0))

Put this formula in cell AA30

Hope it helps you
--

Thank you and Regards

Garreth Lombard


"formula" wrote:

hi..

Datas a

A B C D E
1 AA08 AA07 AA09 AA30
2

I want to display the highest value(AA30) in E1. Any formula for this?
Thanks.