Originally Posted by Adam

Apologies - i've tried finding the answer to this in an already posted
question, but i'm struggling.

I have a code in column A and a date in column G. There are different
combinations of both, plus some codes without dates (blanks), but also
duplicates.

I want to copy these to a different sheet but with only one combination of
each code and date, not including the blanks.

Any ideas?? Much appreciated.

This bit isn't urgent but would be a nice touch!

Once here, I then want to have the top ten (newest date) of each code and
date to go elsewhere. I think this might be using =LARGE?

Cheers