I have an Excel 2007 spreadsheet that contains duplicates of the same work requests. I need to count the unique number of work requests based on other criteria but am struggling to do this.
a1 = 01/01/2011
Worksheet I am calculating data on has information such as:
Work Request Date Raised Vehicle Part Code
WR1365 01/01/2011 truck Exhaust E1234
WR1365 01/01/2011 truck Exhaust E1235
WR1365 10/01/2011 truck engine EG1234
WR1231 15/01/2011 bike chain C1234
WR137 12/01/2011 car wheel W1233
WR137 12/01/2011 car wheel W1235
I want the SUMPRODUCT formula to return that there is 1 Car Wheel query even though there are two rows on the worksheet. I cannot work out how to do this. I appreciate that this is a simple SQL query using MSAccess or the like but I am hoping to calculate this in MSEXCEL instead.