Sorry about the empty post. I had been typing a reply for 15 minutes and then
you push "post" and the programm decides you have top log on again and once
you've done that, your answer is gone..... very handy....

So once again: I cannot find the "unique" button (Excel 2000, maybe that's
the problem, I only have "TOP 10", "Custom" or any of the dates from the
column in the pull down menu, and "custom" doesn't feature 'unique' either).

I used Bob's answer to create a new row with the number of times a date
occurs in it. These two rows I coppied (values only) to a new tab.Then I
sorted and used Pete's answer by means of "=IF(A2<A3, A2, "").
Copy and Paste-special=Values again and another 'sort' and I can finally
copy the data I want.

It works, but takes a lot of time.

I'll keep at it...

Thanks !!!

"R-P" wrote:



"Pete_UK" wrote:

Assume your worksheet is called "Data". Insert 3 blank worksheets.

Highlight the ReveivingDate column, click <copy, move to one of the
blank sheets, select cell A1 and press Enter. Then use Data | Filter |
Autofilter and select Unique Records and Move to Other Location
(specify $C$1) and click OK - this will give you a list of unique
dates, and you can delete columns A and B. You might like to sort the
dates at this point.

Enter this formula in B2 (you should have the heading ReceivingDate in
A1):

=COUNTIF(Data!A$2:A$1000,A2)

This assumes that the ReceivingDate column is A and that you have 1000
records in the Data sheet. Copy this formula down by double-clicking
the fill handle (the small black square in the bottom right corner of
the cursor).

You can repeat this procedure for the other columns in your main Data,
i.e. Type and Customer, copying each to a blank sheet and obtaining a
unique list then entering the COUNTIF formula with the appropriate
ranges of the Data sheet.

Hope this helps.

Pete