Finding unique values within subcategory using function

[ulooz]

Hi,

I have a number of Unique ID's in a column, many of them are dups so I need the count of the # of unique value hits, which I can do using (assuming they are in column A) =SUM(IF(FREQUENCY(A:A,A:A)>0,1)) -So let's say we return 100 results. Now Column A represents two months of data which is housed in Column B - I need the # of unique hits per column A but also for each particular month, so Month 1 would have 80 hits and Month 2 would have 20.

 

[svendiamond]

Assuming your Unique IDs are in column A, and your Months are in column B... and your input values are in D1 (unique ID) and D2 (month) then in D4 you can use:

=SUMPRODUCT(--(A:A=D1),--(B:B=D2))