View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Archengineer Archengineer is offline
external usenet poster
 
Posts: 4
Default Listing Occurences of a date

I have two columns of data. The first column contains five-digit "project"
numbers, the second column contains a starting date (m/d/y) associated with
the project. The numbers and dates are random.

In a third column I have generated a list of dates that are in sequential
order starting with 01/01/2000. To the right of each of these sequential
date cells I would like a cell to list all of the project numbers that
started on that date. There could be up to 12 projects starting on any one
date. I'm not sure how to accomplish this....any help would be appreciated.