# Counting multiple values in a column

1. ## Counting multiple values in a column

Hi, I have multiple values in a column and I would like to find out a way to count them, how many times does each value occur.
If this is possible at all, I got kind of close to the solution by using a pivot table and merging the values but don't know a way to display count.
This would save me a lot of time since I have many tables with these values.
It's really important to me to display the original value and the count number.

Example:
10754005
10024005
10444005
10024005
10024005
10024005
10024005
10024005

Result:
10754005 - 1
10024005 - 6
10444005 - 1

Thanks.

2. ## Re: Counting multiple values in a column

In C1:

=UNIQUE(A1:A8)

In D1 copied down:

=IF(C1="","",COUNTIF(\$A\$1:\$A\$8,C1))

3. ## Re: Counting multiple values in a column

You are amazing, that was fast. Thank you very much!

4. ## Re: Counting multiple values in a column

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1