Hi,
I have a large amount of data that contains a lot of duplicate records. The records can have different states but I just want to count the number of times a specific cell appears in the list of data, without removing duplicates.
<TBODY>
</TBODY><COLGROUP><COL span=7><COL></COLGROUP>
This is a small sample of the data. As you can see in the works reference WR125212 appears a number of times. There are approx 20,000 rows with various different references in this data.
Is there any way I can count the number of unique reference numbers, possibly using a pivot table or a formula?
Thanks
Dave
I have a large amount of data that contains a lot of duplicate records. The records can have different states but I just want to count the number of times a specific cell appears in the list of data, without removing duplicates.
Tag?</SPAN> | Insp. Date</SPAN> | Insp. Time</SPAN> | Insp.</SPAN> | Inspection Type Description</SPAN> | Inspection Outcome</SPAN> | Insp. OD</SPAN> | Promoter Reference</SPAN> |
N</SPAN> | 18/12/2003</SPAN> | 15:01</SPAN> | RTN</SPAN> | Routine Category B</SPAN> | PASSED</SPAN> | LA001</SPAN> | MERS00069694</SPAN> |
N</SPAN> | 07/06/2005</SPAN> | 11:55</SPAN> | D/1</SPAN> | Defect Joint Site Visit Category C</SPAN> | FAIL-LOW RISK</SPAN> | GT001</SPAN> | MERS00075412</SPAN> |
N</SPAN> | 19/08/2005</SPAN> | 00:00</SPAN> | D/1</SPAN> | Defect Joint Site Visit Category C</SPAN> | FAIL-LOW RISK</SPAN> | GT001</SPAN> | CC59463</SPAN> |
N</SPAN> | 13/11/2006</SPAN> | 15:03</SPAN> | D/2</SPAN> | Defect Follow Up Category C</SPAN> | FAIL-LOW RISK</SPAN> | PN001</SPAN> | WR125212</SPAN> |
N</SPAN> | 27/11/2006</SPAN> | 16:00</SPAN> | D/1</SPAN> | Defect Joint Site Visit Category C</SPAN> | FAIL-LOW RISK</SPAN> | PN001</SPAN> | WR125212</SPAN> |
N</SPAN> | 03/01/2007</SPAN> | 09:05</SPAN> | D/1</SPAN> | Defect Joint Site Visit Category C</SPAN> | FAIL-LOW RISK</SPAN> | PN001</SPAN> | WR125212</SPAN> |
N</SPAN> | 30/01/2007</SPAN> | 13:04</SPAN> | D/2</SPAN> | Defect Follow Up Category C</SPAN> | FAIL-LOW RISK</SPAN> | PN001</SPAN> | WR125212</SPAN> |
N</SPAN> | 23/03/2007</SPAN> | 11:01</SPAN> | D/1</SPAN> | Defect Joint Site Visit Category C</SPAN> | FAIL-LOW RISK</SPAN> | PN001</SPAN> | WR125212</SPAN> |
N</SPAN> | 20/04/2007</SPAN> | 09:00</SPAN> | D/2</SPAN> | Defect Follow Up Category C</SPAN> | FAIL-LOW RISK</SPAN> | PN001</SPAN> | WR125212</SPAN> |
N</SPAN> | 09/05/2007</SPAN> | 12:00</SPAN> | D/1</SPAN> | Defect Joint Site Visit Category C</SPAN> | FAIL-LOW RISK</SPAN> | PN001</SPAN> | WR125212 </SPAN> |
<TBODY>
</TBODY><COLGROUP><COL span=7><COL></COLGROUP>
This is a small sample of the data. As you can see in the works reference WR125212 appears a number of times. There are approx 20,000 rows with various different references in this data.
Is there any way I can count the number of unique reference numbers, possibly using a pivot table or a formula?
Thanks
Dave