View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Dorothy[_3_] Dorothy[_3_] is offline
external usenet poster
 
Posts: 3
Default How can I paste a unique values list?

On 24 อมส, 09:57, unique records <unique
wrote:
"jak roodi" wrote:
I have a very big list contains a lot of repeated values and I want to get a
copy of the same list BUT only with unique values. For Example the column
Reg.No. includes the following Numbers:
1154
1168
1166
1154
908455
907558
1166
908455
1154
1166


List might have thousans of records. I want to get a copy of this list
without repeating any of the numbers included. { Uniqe value list }.


Thanks and regards.


JAK


Hi, JAK
You can use an Advanced Filter to extract a list of unique items in
your worksheet
Select a cell in the list
From the Data menu, choose Filter, Advanced Filter.
Choose 'Copy to another location'.
For the List range, select the column(s) from which you want to
extract the unique values.
Leave the Criteria Range blank.
Select a starting cell for the Copy to location.
Add a check mark to the Unique records only box.
Click OK. That's it!

If you want to find unique values between two Excel files then you
should use filord utility from www.filord.com