[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • 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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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