| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Unique value in a list
Hi,
I wonder if anyone could help me solve my problem. I wish to extract just one of each value from a list automatically, as below. Is there a formula to allow me to do this, and if so what is it? James James Mike Mike Dave Dave Peter Peter James Mike Dave Peter James Mike Dave Peter James Mike Dave Peter James |
|
#2
|
|||
|
|||
|
Unique value in a list
Use the advanced filter, select copy to another location and select unique
records. -- Ian -- "news.zen.co.uk" wrote in message ... Hi, I wonder if anyone could help me solve my problem. I wish to extract just one of each value from a list automatically, as below. Is there a formula to allow me to do this, and if so what is it? James James Mike Mike Dave Dave Peter Peter James Mike Dave Peter James Mike Dave Peter James Mike Dave Peter James |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unique occurences in list | Excel Worksheet Functions | |||
| Refresh a Validation List? | Excel Discussion (Misc queries) | |||
| Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| select unique to make list | Excel Worksheet Functions | |||
Hybrid Mode
