Posted by JTG on January 29, 2001 12:52 PM
I wish to locate duplicate data (ID#'s) in two sets of information from two similar databases.
The data consists of a 9 digit unique ID # (for both files)
File a = ID#'s for a condition during 2000
File b = ID#'s for a condition in 2001
(No actual dates are used in the files, just ID#'s)
What want to do is find matches and/or exceptions to the list i.e.,:
file a contains
234567890 (plus 1,000 other 9 digit #'s)
file b also contains
234567890 (Plus about 1,200 other ID's)
and these are the only two matching ID's contained in both Files a & b (But I an unaware and must locate them)
I was using this
and pasting 2000 info in column a then pasting
2001 into column c then entering this formula into b1 and using the Edit Fill Down command.
Is there a better, more efficient way or a lsee confusing way? Thnaks You