Count average number of times unique values appear

Hey all,

I am looking to average the number of times unique values appear in a list using a formula. For example, if there are three numbers in the list: 1,2,3, and the number one shows up 1 time, number two should up three times, and number three shows up two times, the average number of instances of each value would be 2.

I have included an example in the attached.

One of the challenges is that the list in my actual document is quite long, and you don't know how many unique instances there will be, or how many times each will be duplicated.

Cheers,
B

Hi Ali,

thanks for the response. Do you know if it is possible to solve the problem with one formula based on either of the two columns that are there? Adding a column to the file I am working on will be a challenge because the data is a bit of a mess, and I need the "instance" column to be there.

B

Nevermind! Got it from what you posted!

Thanks!