i have numbers in cell A1 to A35
i am using the condition formatting 'TOP' (1) to find the highest number but i cannot find a way to find the runner-up number
please help. thanks
10
9
20
21
22
33 so here, it's the highest number and i can find it with TOP 1
1
0
6
32 and here is the next (runner up) number. how can i mark it.
22
i am using the condition formatting 'TOP' (1) to find the highest number but i cannot find a way to find the runner-up number
please help. thanks
10
9
20
21
22
33 so here, it's the highest number and i can find it with TOP 1
1
0
6
32 and here is the next (runner up) number. how can i mark it.
22
118,000 | 27.44% |
50,000 | 11.63% |
40,000 | 9.30% |
0 | 0.00% |
50,000 | 11.63% |
16,100 | 3.74% |
118,001 | 27.44% |
5,000 | 1.16% |
8,000 | 1.86% |
5,000 | 1.16% |
20,000 | 4.65% |