| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
sort list
perfect.
thanks a lot to both of you! "RichardSchollar" wrote: Hi Your easiest option to achieve this would be to use Advanced Filter - Select your range (ie A1:A100 or whatever) and go DataFilterAdvanced Filter. In the dialog that opens, select "Copy To Another Location", check "Unique Records Only", and seletc a destination for your unique records (eg B1). Hope this helps! Richard On 30 Jan, 09:21, massi wrote: I have a list with item repeated more than once: item A item A item B item B item B item C item C in the next column i would like to list all the items once only item A item B item C how can i do that? rgds |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want sort a list but the sort is unlit on the home tab how do I | Excel Worksheet Functions | |||
| Sort with a List | Excel Worksheet Functions | |||
| Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
| sort list of players by team from player list on separate sheet | Excel Worksheet Functions | |||
| Can you sort a list based on catagory names without useing a custom list? | Excel Programming | |||
![massi[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
