Counting the same cells in Excel

0
votes

I have a list of more than 2000 entries. I need to count the same entries and unique ones. For example, Excel will show that the cell, 'Out of cartridge', repeated 3 times. However, since I have more than 2000 cells, I can't use COUNTIF function because I can't write what to search in formula for thousands of entries. So, is there any formula I can use?

1
excelsearchcount

1 Answers

1
votes

This can be achived by applying Pivot, do the following

  1. Select the entire column which you need to count
  2. Select Insert -> PivotTable option
  3. On Pivot Table filed list drag and drop the same field to Row Lables and values.

enter image description here