comparing lists (columns)

  • Thread starter Thread starter Greg P.
  • Start date Start date
G

Greg P.

Is there a way I can compare 2 separate columns (ranges,
NOT specific numbers) and have access pull out and list
any exact matches?

If I have 1 column that has over 20,000 numbers (rows) and
my 2nd column have 700 numbers (rows)...I need to see if
any of the 700 are also listed among the 20,000.

If this is possible, can I do this across worksheets?
 
You need to create a query in Access. Import the two data
sources to an access database and then use the Query
Wizard to write the query. If you get stuck send the data
to me directly and I will write it for you
 
Back
Top