Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How to find the next average ?

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.

Posted on Apr 18, 2013 3:24 AM

Reply
Question marked as Best reply

Posted on Apr 18, 2013 4:53 AM

you can use: countif()


User uploaded file


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

2 replies

How to find the next average ?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.