View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
R-P
 
Posts: n/a
Default Counting reoccuring dates.

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