Count a unique number based on 2 other criteria’s

[pmw19800]

Hello All
Please see attached

C21 = Looks at column A and column L and returns the number of unique vales in column A, using A21 as a criteria

I need a 2nd criteria “Sep” B20

Paul

[queuesef]

I'm not sure I understand the problem....but you may want to investigate Pivot Tables? They can aid in summarizing data. I filtered some of your data - I hope this leads you on the right path. I had to add Labels to your data for Pivot Table to work. What's nice about Pivot tables(PT), is that once you have them in PT you can Pivot the data - by dragging a column to a row or vice versa.

[Bo_Ry]

Please try

=COUNT(1/FREQUENCY(IF($L$2:$L$12=A21,IF($N$2:$N$12=$B$20,MATCH($A$2:$A$12,$A$2:$A$12,0))),ROW($A$2:$A$12)-ROW($A$2)+1))

[pmw19800]

Pivots isnt realy an option, Was hoping for formula

[Fluff13]

How about
=SUM(--(FREQUENCY(IF($L$2:$L$12=A21,IF($N$2:$N$12=$B$20,MATCH($A$2:$A$12,$A$2:$A$12,0))),ROW($A$2:$A$12)-ROW($A$2)+1)>0))

[wk9128]

C21 cell array formula

[pmw19800]

Thanks, All worked well

Special thanks to Bo_Ry

[Fluff13]

Glad to help & thanks for the feedback.