Count of Distinct function/ Formula based on multiple criteria

Dear All,

I have a dataset with lots of data and duplicate names on other geographies and report from same area on multiple days
So I need a condition based on Geographic and based on day [Orange highlighted] ... ONCE the unique value is identified so i need "1" in front of that row.

Earlier i had a similar question of which was sorted with following formula:

Formula:

Please Login or Register  to view this content.

Here is a little modification is that earlier condition was limited to two duplicates whereas in this dataset i can have data upto 7 days for each area starting from any day upto 7.

I have given at the end of table what I want from FORMULA.

CR Data.jpeg


Attachment for kind reference.