| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List unique
I am using EXCEL 97
I have a column iof names in a spreadsheet, some of these entries are repeated and I want to list on a separate worksheet each unique enrty. Can anyone assist me with some code, please? -- Mark |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
List unique
One way is to use an advanced filter. See Debra Dalgleish's site for
help: http://www.contextures.com/xladvfilter01.html#ExtractWs For code, you can record and edit a macro using her procedure. Alternatively, see http://cpearson.com/excel/duplicat.htm In article , "Mark" wrote: I am using EXCEL 97 I have a column iof names in a spreadsheet, some of these entries are repeated and I want to list on a separate worksheet each unique enrty. Can anyone assist me with some code, please? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula (not adv. filter) to list unique values from list | Excel Worksheet Functions | |||
| How to pick out unique components in a list with unique and common | Excel Discussion (Misc queries) | |||
| how to identify unique list of 200 random entries from a list of 3 | Excel Worksheet Functions | |||
| Identify & List unique values from a list using functions/formulas | Excel Worksheet Functions | |||
| How can I average data from a repeating list into a unique list? | Excel Worksheet Functions | |||
![Mark[_50_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
