Summary List??

[Guest]

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]

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

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

 

[CLR]

I use an Add-in called "XL Companion"...........it does the trick nicely.

Vaya con Dios,
Chuck, CABGx3