| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
sort list
ok.
will do thanks "Roger Govier" wrote: No, that's what happens if the list does not have a header. Put a header in, even if you delete the row after you have carried out the Advanced Filter. -- Regards Roger Govier "massi" wrote in message ... if i don't include the header the first item is repeated twice. am i doing something wrong? "Roger Govier" wrote: Hi One way Insert a row above your data. Type in a Header e.g. List Mark the block of data including header, then DataFilterAdvanced FilterCopy to choose your next columnclick Unique items -- Regards Roger Govier "massi" wrote in message ... 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
