# Display distinct values and their counts

1. ## Display distinct values and their counts

I have a list of terms in Col D.
I would like a distinct list in Col F and in Col G I would like a count of the distinct terms displayed in Col F from Col D.

For Col F I am currently using the following formula and it is working great.
=IFERROR(INDEX(\$D\$2:\$D\$2000, MATCH(0,COUNTIF(\$F\$1:F1, \$D\$2:\$D\$2000), 0)),"")
Any suggestions on this?

I am unsure what to do about Col G.
I have this, but it isn't working.
=SUM(--(FREQUENCY(IF(\$D\$2:\$D\$2000=F2,MATCH(\$D\$2:\$D\$2000,\$D\$2:\$D\$2000,0)),ROW(D2:D2000)-ROW(D2)+1)>0))

Thoughts, ideas and musings welcomed.
excel.PNG

2. ## Re: Display distinct values and their counts

I might be oversimplifying and/or missing what you are asking but in cell G2, can you not use =COUNTIF(D:D,\$F2)? Copy & paste down as needed...

3. ## Re: Display distinct values and their counts

You are exactly correct omccabe!
Apparently the first formula drained my brain and something like this was just beyond me. Thanks so much!

#### Thread Information

##### Users Browsing this Thread

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