Tag Info

New answers tagged


In addition to pnuts solution, this conditional format custom formula may be applied to the same range: =COUNTIF(I$13:I$34,">"&N(I13))<4 For 10, 9, 9, 8, 8, 7, this will return 10, 9, 9, 8, 8 (ie the tie won't be broken for "last place"). To break that tie, and therefore return no more than 4 values: ...


Apply this Custom formula is: =or(I13=large(unique(I$13:I$41),2),I13=large(unique(I$13:I$41),3),I13=large(unique(I$13:I$41),4)) to Range: I13:I41 and change ColumnI references throughout to E for a separate rule. Note that this applies to the second, third and fourth highest values however many instances of each there may be. So for ...

Top 50 recent answers are included