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

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.

Solved by Wayne Contello on Apr 18, 2013 4:53 AM Solved

you can use: countif()

 

Screen Shot 2013-04-18 at 6.52.37 AM.png

 

C1=row()

D1=COUNTIF(A, "="&C1)

 

 

select C1 and D1, then fill down as needed (to row 10)

 

now you can see the count of each number 1 thru 10