Excel 2007 : Count Unique Records

**stevetothink** · 11-04-2011, 04:10 PM

I searched the forum on counting unique records. There are a lot of posts but I can't get any of the solutions to work. I'm trying to count unique records by quarter (Q1, Q2, Q3, Q4). I've attached a sample of what I'm trying to do. The yellow fields are the ones I'd like to automatically count unique records.

Any ideas on how to do this?

Thanks,
Steve

**daddylonglegs** · 11-04-2011, 04:14 PM

Hello Steve,

To get those results you can use this "array formula" in H8

=SUM(IF(FREQUENCY(IF(B$2:B$16=G8,IF(A$2:A$16<>"",MATCH(A$2:A$16,A$2:A$16,0))),ROW(A$2:A$16)-ROW(A$2)+1),1))

confirm with CTRL+SHIFT+ENTER

and copy down to H11

The formula can be quite slow if you have a large amount of data....