comparing lists (columns)

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?
 
B

Bish

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Finding the proper style field and the numbered paragraph value within the style 0
VLookup Function HELP 7
Finding the right style field in VBA 0
Copy addition formula of non-consecutive horizontal cells 2
List all tables, including document structure 0
Format column widths from one table to a separate table on same page 1
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0

Top