Find Unique with condition

[MohitMathur1234]

Hi All,

I am stuck to find out Unique value year wise through formula for dashboard, When I select 2015 from drop down then Unique count will come and same for 2016
I have 2 columns 1- Year and 2- Values

 

[bosco_yip]

Unique count, G4 formula copy down :

=SUM(IF(FREQUENCY(IF(MMULT(-(A$2:A$440=F4),1),B$2:B$440),B$2:B$440),1))

Regards

 

[MohitMathur1234]

Hey, One more question please..
If I have 2 condition like before year column I have gender too, so how can I add 2 condition , One is already there like year

 

[bines53]

Hi ,

It is also possible that,

=SUM(--(FREQUENCY((A$2:A$440=F4)*B$2:B$440,B$2:B$440)>0))

2 conditions, you mean two years?

David