Posted by Kevan on October 08, 2001 7:46 PM
I have a column of 14 numbers. Below that I have the formula =sum(A1:A14), This of course adds all 14 numbers together.
My problem, I wish to eliminate the 2 lowest of these numbers, hence, I am only showing the total for the top 12 numbers.
If the lowest number is 1, and there are two number two's, I only want to eliminate one of the two's, and the one. Still leaving twelve numbers being added.