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
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....
Audere est facere
with ex 2007 you can use remove.duplicate and use pivot table
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks