On the same Note (Unique Values).....
I have two columns (A1:A88) and (B1:B90)....the columns have some similar
data but I would like to filter out the data that is not unique to either of
the columns. In other words...my results should only give me data that is not
similar in both records. A majority of the data is similar but I want to
filter out data that does not match on both columns.....ANYONE???

"Dorothy" wrote:

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