You can use an Advance Filter to filter for unique values. There are
instructions in Excel's Help, and he

http://www.contextures.com/xladvfilter01.html

Tray wrote:
I have a list of codes, eg:
KMDE1
DFER0
DCMF1
DFER0
FRRT4
KMDE1
TGRY3
KMDE1

Is there a quick way I can produce a summary list of these codes, showing
all the codes that appear ie. no duplicates. So for this example, it would be
KMDE1
DFER0
DCMF1
FRRT4
TGRY4


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html