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.