=COUNTIF(A:A,A1)

etc.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"R-P" wrote in message
...
Hi,

Hope this isn't a double post, previous try ended in "server too busy".

I have an Excelsheet with columns "ReceivingDate", "Type" and "Customer"
(and some other columns that don't matter).

I need three lists that show me every date that's in "RecevingDate" with
the
number of times it showed up in the list in the next column.
Same with "Type" and "Customer".

So endresult should look like this:
Column1.....Column2.....Column3.....Column4.....Co lumn5.....etc.

6/13/2006...2...............ModelX.......4............. ...Hainz.........etc
4/28/2006...1...............ModelY.......2......etc.
etc.
Column 3 and 4 and Column 5 and 6 can be on a different Tab because I will
copy and paste the results in another report anyway.

Thanks,
R-P