M
M
markmarkmark2019-06-12 21:57:07
Google Sheets
markmarkmark, 2019-06-12 21:57:07

How to count duplicates in google spreadsheet?

There is a table with unloading categories and products. You need to count how many products are in each category.
To do this, I just left a general list of categories (there are now 1500 of them, the number of products in each). The result is one list in which, for example, the category "Shoes" occurs 560 times. So there are 560 products in the category shoes.
How to make a general summary for all categories? TO have the table count the number of duplicates and output the sum for each unique value

Answer the question

In order to leave comments, you need to log in

2 answer(s)
O
ozket, 2019-06-12
@ozket

Judging by the description of the task, the following option is suitable:
1. Display all unique category values ​​in a separate column using the UNIQUE function
2. Count the number of duplicates for each category using COUNTIF
5d015dcdc915e325752714.png

R
Roman, 2019-06-13
@JohnnyBravo7

The answer above is correct, but if a new value is added, then you will need to extend the formula further
There is another, more optimal option
=QUERY(A1:A,"select count(A),A group by A")
Select a range of values; specify the column to be counted; rejoice

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question