Using COUNTIF() to count unique values

Asked Aug 31 '23 at 15:59

Active Aug 31 '23 at 18:02

Viewed 44 times

-5

I would like to figure out the best way to count how many times a unique value in column A:A shows up in my data.

actually i want this output

Count the occurrences of "Cheepurupall" until the function reach the different data.

i.e means every concurrent occurrences is different data,

edited Aug 31 '23 at 17:44

asked Aug 31 '23 at 15:59

Yaser Arafath

just e-g, it might vary kumar to other name – Yaser Arafath Aug 31 '23 at 16:09
Look into Countif – P.b Aug 31 '23 at 16:19
You could use COUNTIF() or use a PivotTable using the count function in Values. – Joaquin Aug 31 '23 at 16:47
2

`=IF(B1=B2,"",MATCH(FALSE,$B2:$B$22=B2,0)-1)` : https://i.stack.imgur.com/cMj5K.png – BigBen Aug 31 '23 at 18:19

0 Answers0