MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Ron Piasecki on August 31, 2001 9:01 AM

I am currently using Excel 2000. Here is my situation. I have a column of numbers starting at C2:C5. I need to find the largest value, remove it and re-calculate the column of numbers to find the next largest value. I can use the MAX command to initially find the largest value, but I am having a hard time figuring out how to remove that initial value and re-calculate to find the next largest number. Please send me a email with the answer.

Thanks, Ron

Posted by Aladin Akyurek on August 31, 2001 9:08 AM

Use the LARGE function.


This will give you the second largest value from A1:A100.