Hello I have a formula looking for the 4th smallest number in a range, the formula I have is =IFERROR(SMALL(CF123:CH126,4),"") Problem becomes on occasion the 3rd and 4th number could be the same as in example below so in that case I would want it to look in the two rows containing the 165.50 and eliminate the row with the lowest number if that makes sense, What my actual goal is out of the four rows in the example I am trying to do a tank split calculator for the air seeder on my farm, I have three products and three different sized tanks I use I am trying to have it figure out which arrangement of the four will allow me to seed the most acres, In this case it is the second row
129.02 | 165.50 | 486.00 | |
188.91 | 165.50 | 243.00 | |
182.26 | 174.50 | 243.00 | |
251.39 | 81.00 | 243.00 | |
165.50 |