2 Replies Latest reply: Apr 18, 2013 4:57 AM by mtiffen
mtiffen Level 1 Level 1 (0 points)

I need to find the next most common number from a list of numbers.

 

For example:

 

A

 

1

1

3

4

5

5

5

5

6

6

7

7

7

8

8

9

 

The function: =MODE(A1:A16) would give the answer 5. I want to find the next most common number in the list which is 7, How would I implement a function to do this ?

 

Or am I going about this the wrong way, should I be looking at the Frequency function ?

 

Thanks Mark.