Need to find how many times items from a particular date are duplicated throughout sheet

Hello All,

This forum has been a life saver for me in the past, so I turn to your collective knowledge yet again.

I have two sheets. One is named "Detail" and the other is "Results". The "Detail" sheet will have my entire data range. In that data range there are a number of columns. One of the columns is titled "Work Order". There is also a column titled "Date". I need to find how many times the work orders on a specific date are duplicated throughout the whole data range and have those results displayed on the "Results" sheet.

So, the final result would be something such as: 10 of the items were not duplicated at all, 5 were duplicated once, 7 were duplicated twice, 4 were duplicated three times and 7 were duplicated 4 or more times

The number of rows containing data on the "Detail" sheet will change each week.

I'm not sure if VBA is the best approach to this or if there is another way maybe with a formula or a pivot table, or some other way that I'm not aware of.

Either way, I appreciate any help.

Thanks

Thanks for the response FDibbins.

I don't think COUNTIF will work because I'm not trying to find out how many times a particular item is duplicated. I'm trying to find how many items have been duplicated once, twice, three times and four or more time. Per your request I've attached a very simplified version of what I'm trying to accomplish. In the real workbook there are about 10 column headers on the "Detail" sheet and each week there will be about 100 more rows of data added to the "Detail" sheet.

Thank you for your help.

**Bump**

Hoping someone can help me out here. Let me know if there is any more information I can provide.

Thanks.

Got a solution here: http://www.excelforum.com/excel-char...ate-chart.html

Thanks