Need help with a comparison problem

  • Thread starter Thread starter Captain
  • Start date Start date
C

Captain

Here is the situation. In Excel (because everyone at my work knows how to
use it and does NOT know Access), we keep a list of names and addresses.
The list I have is in such a way that when I have an updated list, I can't
simply overwrite it. Therefore, my problem is I want to be able to use a
tool in excel to compare the two lists. I know I can integrate both lists
in 1 worksheet and do the sorts and eyeball duplicates and new names and
such. Each name has a unique ID #. I tried using a cell comparison formula
IE =if(c2=c3, "Y", "N") and it worked well until it came to a new ID# and
then all the rest of the way down the result was skewed.
I'm thinking some program needs to be written in a Macro? I hope not,
because thats why I'm posting this question.
If anyone can help, please do so.
Thanks a mill!
 
Captain

If you are trying to avoid the entry of duplicate IDs, then likely you need
code. Probably a worksheet_change event. If this is the case, post back

If you are just looking to identify duplicates you could either (Data in
A1:A100)

Use a COUNTIF formula =COUNTIF($A$1:$A$100,A1) and copy down. This will
give a count greater than 1 on any data with duplicates.

Use Advanced Filter (Data>Advanced Filter...). Copy the ID# header to a row
at the right, at least one column from the other data. In the dialog, after
selecting the menu options, select the range to filter. (All the original
data) and then for the criteria select the newly copied ID# Header and the
empty row below. Now select a cell to the right of all the data for the
range to copy to and select Unique Values Only. You should now have a list
of Unique IDs
 
Back
Top