Filter for unique value
As long as you have some column within the data which is a unique
reference (like an employee number, or stock code) then you can use
the MATCH function to see if the item in a particular record is
contained anywhere in the other data set - the formula is copied down
and would return something like "not present" if there is no match. A
similar formula can be used in the other data set to see if those
records are contained within the first data set. Then it is just a
matter of applying autofilter to the data sets to check for "not
present" to determine the unique values.
Hope this helps.
Pete
On Jun 17, 12:11*am, Christi Witte <Christi
wrote:
I have 2 sets of data that should be identical but I know they are not - how
can I filter so that it gives me only the unique values? *I have found ways
of filtering to delete duplicates but that doesn't tell me which cells are
unique to that set of data.
Thanks if anyone can help
|