How to get the Largest Value in a RANGE

Posted by David Holstein on March 05, 2000 3:17 AM

Hi,

I would like to know if you can obtain the LARGEST value in a column depending on a value in another column that appears frequently and not in sequence. Possibly the formula would be something like LARGEIF

Thanks in advance.

Regards
David

Posted by bill.roberts on March 06, 2000 11:39 AM

try MAX()

bill