Marking Distinct Values in Table based on multiple conditions

Dear All,

I am looking for a formula in a long datasets (Excel table) to identify Distinct Values based on multiple conditions.
For Example:
When Type = ONE, Year = 2019 so it should count that District and return 1 and skip the rest values in that year

In past sheets, I have been using COUNTIFS but it is not accurately working here modified for this reason as below

Formula:

Please Login or Register  to view this content.

and

Formula:

Please Login or Register  to view this content.

If you see in below picture so for 2020 it is working but in 2019 column its showing for 2020 as well (marked as red)

Excel.jpg

Please draft me an alternate or correction in above to get the desired results

Try this:

=IF(AND(COUNTIFS($A$3:$A3,"ONE",$B$3:$B3,2019,$C$3:$C3,C3)=1,B3=2019),1,"")

Dear All,

This need some work now as I found that when there is single value for the year so it pick it otherwise it wont.. See below Screenshot as 2020 is only one district so it is picking as 1 but 2019 is all blank with same formula.

What i want is that one district, One type and one year should return me value as 1 and rest repeating district in those categories should be blank.

For 2019:

Please Login or Register  to view this content.

For 2020 same formula:

Please Login or Register  to view this content.