| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Summary List??
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
I use an Add-in called "XL Companion"...........it does the trick nicely.
Vaya con Dios, Chuck, CABGx3 "Tray" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
| Drop dow list complication | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
| List Box refer to an array | Excel Discussion (Misc queries) | |||
| Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) | |||
Linear Mode
