Please Help: compare values in two columns present in seperate tab

S

sam

Hi All,


How can I compare values in two columns (columns are in different tables) ?
I also want to display the values that dont match in a seperate table.

For eg:

If values in Column1 from Table1 does not match Values in Column1 from
Table2 then display those values in a seperate table

Is there a way to do this?

THanks in advance
 

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

Please Help: compare values in two columns present in seperate tab 2
Complex Queries 1
return nulls from double column join 2
Getting column values into row values (transpose) 1
wildcard symbols around a field in a join? 6
VBA - retrieve data on last create named range from previous inserted named range 0
query to update based on similarity 1
Expression using multiple conditions 4

Top