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:
=IF(COUNTIFS($A$3:$A3,"ONE",$B$3:$B3,2019,$C$3:$C3,C3)=1,1,"")
and
Formula:
=IF(COUNTIFS($A$3:$A3,"ONE",$B$3:$B3,2020,$C$3:$C3,C3)=1,1,"")
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
Bookmarks