Hi,
I have an Excel sheet containing a list of product repairs.
The list can be of warying length - depending on the product in question, and period monitored.
Each product is represented by a serial number (column A).
The can be sorted on column A from smallest to largest prior to calculating results if that helps.
The repair list contains 1 entry per spare part used, so the same serial number may occur several times.
Furthermore, a product may have been repaired on several instances - so the serial numbers can span several dates (column B).
The solution i am looking for should return the number of unique repair dates per serial number. That way i can see, how many times each product has been repaired. Results can be displayed in an individual column.
Sample list:
Serial........Repair date
20774205 2008-09-04
20775508 2008-12-17
20775521 2008-12-31
20775521 2009-01-22
20775521 2009-01-22
20775521 2009-01-22
20775521 2009-02-13
20775521 2009-07-24
20775536 2009-05-20
20775553 2009-07-16
20777012 2008-11-13
20777049 2009-03-27
20777049 2009-03-27
20777049 2009-04-03
20777068 2008-08-22
20777068 2008-08-22
20777068 2008-11-17
For instance - serial number 20775521 has been repaired on 4 unique dates.
I am a complete novice with regards to using macros/programming in Excel, so please add information about how to implement such a solution.
Can anyone help?
Bookmarks