MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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