I have a table in a sheet and I want a formula that will count the unique records. The simplified database is as follows (in a table):
Date Job# Item
1-Feb 10 material
1-Feb 10 parts
1-Feb 10 labour
1-Feb 11 labour
2-Feb 12 parts
2-Feb 12 material
2-Feb 13 labour
2-Feb 14 labour
As you can see, on the 1-Feb, there are 4 records, but only 2 unique job numbers. There are 3 unique numbers on 2-Feb.
So I would like a forumula that will count the unique numbers in the job# column for a set date. I would have thought sumproduct could do it, but I haven't had any luck. I am open to any suggestion that can return an answer in a cell (ie I don't want to use a pivot table or summarise the table etc).
Bookmarks