Generate a unique number of list

[Terence Chan]

Hey all,

I have a list of number which some is repeated, how can I regenerate a
list with unique number. e.g


1
2
1
5
3
5

Expected Result

1
2
5
3

Thanks for any one who can help.

 

[Roger Govier]

Hi Terence

One way
Mark your range of data, Data>Filter>Advanced Filter and Select Unique
values only.
Copy the data to a new location.

Regards

Roger Govier

 

[Bob Phillips]

Take a look at Data>Filter>Advanced Filter. There is a copy unique option.

--
HTH

Bob Phillips

"Terence Chan" <[email protected]>
wrote in message
news:[email protected]...

 

[quocnghia]

Not Advance Filter, use function, view ex


+-------------------------------------------------------------------+
|Filename: loc3.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3819 |
+-------------------------------------------------------------------+