An alternative to the function-based solution would be to sort the data
by columns A, the course id, as the primary key and B, the date, as the
secondary key. This will give you a complete list of all courses and
all wait-list dates. To restrict to a single course, use a auto-filter
based on A.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hello,
Is this possible...

I want excel to scan column A which contains course codes
some of which will be the same.
Then I want excel to compare the same course codes with
the corresponding entry date entered in Column B.
In column C I would like excel to generate a numbered
list base on same course code and the date entered.

This is basically a course waiting list that will assign
a priority number to an individual who wishes to be
placed on a course waiting list based on the date they
made the request.

Any suggestions are appreciated,

Rekoop