Return the 2nd and 3rd most common values from a column

Try this:

1st

Formula:

Please Login or Register  to view this content.

2nd

Formula:

Please Login or Register  to view this content.

3rd

Formula:

Please Login or Register  to view this content.

Another way.

In B1 this formula filled across until you get blanks.

Formula:

Please Login or Register  to view this content.

Row\Col	A	B	C	D	E
1	5	1	8	11	=IFERROR(INDEX($A$1:$A$40,INDEX(MATCH(LARGE(FREQUENCY($A$1:$A$40,$A$1:$A$40),{1,2,3}),(FREQUENCY($A$1:$A$40,$A$1:$A$40)),0),COLUMNS($B:B))),"")
2	11
3	5
4	4
5	9
6	7
7	1
8	9
9	3
10	11
11	2
12	1
13	10
14	12
15	4
16	6
17	11
18	8
19	6
20	3
21	9
22	2
23	12
24	8
25	8
26	1
27	2
28	1
29	8
30	1
31	7
32	1
33	10
34	6
35	8
36	12
37	4
38	7
39	11
40	9

Many members are unable to see images in the *.png format due to forum compatibility issues with some browsers.

If you need to post an image post it in the *.jpg format.

Even better than posting images... post a SMALL sample file. That way we can test solutions directly in the file with the relevant data.