Hi again Guy,
Must have something wrong if can’t filter to new location. Following is
instructions to filter one column only.
Select menu item Data->Filter->Advanced filter. (For pre xl 2007 versions)
(for xl 2007 it is Data tab->Filter->Advanced filter)
Select Copy to another location.
List range:
Click on the icon at the right of the field box.
Select the range to be filtered including the column header for the one
column only with the numbers.
Click on the icon at the right of the field box.
Copy to:
Click on the icon at the right of the field box.
Select one cell only somewhere on a blank section of the worksheet. (Select
E1 and it will make the section below easier to understand)
Click on the icon at the right of the field box.
Check Unique records only.
Click OK.
You should now have a list of only the first column with the column header
in cell E1.
Enter the following formula in cell F2:
=VLOOKUP(E2,$A$2:$B$9,2,FALSE)
Note: the range to look in with the above formula is in absolute mode with
the $ signs. This is so that as you copy the formula down, it does not change
like E2 does (which is required to change)
Copy the formula to the bottom of the data in column E.
Note that it only finds the first instance of a name against the numeric
identification.
If you filter on both of the columns and then filter on the numeric id
column then you will be able to easily see if you have duplicate numeric id’s
with different names against them.