Forum Discussion
Counting All Duplicate Data In One Column
Hi All, I'm wondering if there is a formula/function or alike to count the amount of times data appears in a column. To further explain, I have a parts catalogue I'm currently working on. It has a li...
The easiest way is insert a Pivot Table based on your data, drag the Categories field into the Row area and drag the Categories field again into the Values area.
Another way is, import your data into Power Query editor and then use Group By feature to group the data by Categories with Count Rows operation to get a table with all the unique categories in one column along with their counts in another column and load the resultant table back into the sheet.