Hi,

I've got a range of numbers, J5:J28. I can get the maximum value
using:

=max(j5:j28)

However, I want to find that max number and find the offset value 1
column to the left.

Is this possible within a formula?

I've tried all sorts of combos with MAX and OFFSET but can't get this
one.

Any help would be appreciated.

Thanks,
Dan.


--
Voodoodan
------------------------------------------------------------------------
Voodoodan's Profile: http://www.excelforum.com/member.php...nfo&userid=597
View this thread: http://www.excelforum.com/showthread...hreadid=373856