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


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.


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

try MAX()