![]() |
|
#6
|
||||
|
||||
|
Okay. An easy way to extract distinct values is to put a column heading in Row 1 of that column and then use the advanced filter to extract unique values. Extract it to a different range and the results will not contain the duplicates.
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| number to text | acki | Excel | 1 | 01-26-2012 07:47 AM |
convert to number
|
gsrikanth | Excel | 1 | 01-09-2012 01:01 AM |
| number change 11 to 12 | uoume | Office | 0 | 10-30-2011 06:33 PM |
Mailing: how to make the "page number" in Word is the same as "row number" in excel w
|
Jamal NUMAN | Word | 1 | 09-03-2011 11:37 AM |
Last Number in a Column
|
paulrm906 | Excel | 1 | 12-05-2008 07:51 PM |