Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 243
  • Last Modified:

excel, how do we count how many same values exist in Column D

I have excel sheet from colum A - G, I would like to know how do I find how many same values exist in column D
0
motioneye
Asked:
motioneye
3 Solutions
 
mohamedazmalCommented:
You can use
=COUNTIF ( Range, Criteria)

For example,
=COUNTIF(D:D,D1) -> it will give you the number of times the D1 values exists in D column.

If the above is not helpful, please provide example for your request
0
 
Rory ArchibaldCommented:
If you mean how may distinct values:

=SUMPRODUCT(1/COUNTIF(D1:D100,D1:D100&""))

adjust the ranges as required.
0
 
helpfinderIT ConsultantCommented:
use pivot table where you can see count of each value
check my example for oyu in attachment (imagine my column "Gender" is yours G)
sample.xlsx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now