|
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 |
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 |
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 |
| All times are GMT +1. The time now is 07:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com