But you asked for the adjacent column. To do what you want needs two
columns, one to get a list of uniques, one for the count.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"R-P" wrote in message
...
Works, but has an unwanted catch:
7/13/06..1
6/5/06....5
6/5/06....5
6/5/06....5
6/5/06....5
6/5/06....5
5/18/06..2

I'd rather have:
7/13/06..1
6/5/06....5
5/18/06..2

I'll try Pete_UK's solution, but since I have to do this every week, a
less
labour intensive approach would obviously be prefered.

Thanks so far, will try to continue with both your answers to get the
endresult I want.










"Bob Phillips" wrote:


=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