It might be easier if i just explain my scenerio.

In each row of my spreadsheet is one person.
The code (Column A) represents a course that I run.
The date (Column G) represents the date that it ran.
Not everybody has a date arranged yet and so there are also blanks in Column G.
There is usually 60+ people attending each course.
More than one course can occur on one day.

What I would like is a function (on seperate sheet) to put

A list of the dates with the newest at the top in Column A
The course code in Column B
Only have one duplicate of each code and date combination

This would mean there maybe duplicates of the date when there is more than
one course on that day.

For example-

Column A Column G

PSPNUR 02/Apr/08
PSPNUR 08/Apr/08
PSPNUR 08/Apr/08
USNUAD 02/Apr/08
PSPNUR 02/Apr/08
USNUCB 16/Apr/08
USNUCB 16/Apr/08
USNUCB 15/Mar/08
USNUAD 10/Apr/08
USNUAD 10/Apr/08
PSPNUR 10/Apr/08

Turns into

USNUCB 16/Apr/08
USNUAD 10/Apr/08
PSPNUR 10/Apr/08
PSPNUR 08/Apr/08
PSPNUR 02/Apr/08
USNUAD 02/Apr/08
USNUCB 15/Mar/08



Hope you can help!