First of all, I know about the unique function available on MS 365/ MS office 2021. But my company wont upgrade to those versions. so I'm stuck with 2019.


I need to Count Unique value & count only duplicate value of a excel sheet. I have explained it in attached excel sheet.


So please help me if anyone can.

Attached Images

TEST COUNT.png (68.0 KB, 23 views)

Attached Files

TEST COUNT.xlsx (32.4 KB, 6 views)

Count unique try the other



(both committed with CSE I think)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks @Pecoflyer for your solution. generally it works but it losses its count when i add text to OP id. sometimes text is required to be mentioned along with ID number.


Also im trying to figure out if can how many OP is present in a individual "A" group (A1 to A12 M/C), then "B" group (B1 to B12 M/C). I cant give cell range like AK8:AK30,AK8:AK30 , because A1 to A12 M/C range will vary. sometimes it will be AK8:AK38 or AK8:AK25 or AK8:AK42 etc.

It needs to be somthing like this " =SUMIFS(AK:AK,AK:AK,C:C,C:C,"A*") "

Attached Files

TEST COUNT 2.xlsx (31.0 KB, 4 views)