| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Sort data
Advanced Filter.
Unique records only and copy to another location. Gord Dibben MS Excel MVP On Wed, 30 Sep 2009 05:35:01 -0700, Graham wrote: Hi I have a list of text in one column in this format:- ab-21 ab-21 ab-21 ab-22 ab-22 ab-23 ab-23 ab-23 ab-23 what i need to do is just show one of each text, so it will be like this:- ab-21 ab-22 ab-23 any ideas?? thanks Graham |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
| Help to sort out filtered data from the data contained in another sheet of the same workbook | Excel Worksheet Functions | |||
| I want to convert word column data to excel row data to sort addre | Excel Discussion (Misc queries) | |||
| data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
| How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) | |||
Threaded Mode
