Forum Discussion
Solved
How to count occurrences of different multiples in one list
I have a list of 1430 rows, and 4 columns. It's a shirt designs inventory. One of the columns is the folder name where the design is located. For example, this column is structured like this. Fol...
One option is to create a Pivot Table based on the data.
Add the folder column/field to both the Rows area and to the Values area.
Another option:
In one empty cell, let's say in K2, enter the following formula:
=SORT(UNIQUE(folder_name_range))
In the cell next to it, i.e. in L2, enter the formula
=COUNTIF(folder_name_range, K2#)
One option is to create a Pivot Table based on the data.
Add the folder column/field to both the Rows area and to the Values area.
Another option:
In one empty cell, let's say in K2, enter the following formula:
=SORT(UNIQUE(folder_name_range))
In the cell next to it, i.e. in L2, enter the formula
=COUNTIF(folder_name_range, K2#)