Is there a formula that will compare elements in one column to an.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can I compare information in one column with information in another column
and highlight the results?
 
Can I compare information in one column with information in another column
and highlight the results?
Click to expand...

SELECT * FROM YourTable WHERE ThisColumn = ThatColumn
 
Or

SELECT *, IIf([ThisColumn] = [ThatColumn], "Same", "Different") AS
Comparison
 
You must log in or register to reply here.

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 Comparing two columns 1
Help needed 0
Macro for comparing columns and highlighting matching/differences 14
Excel Help to copy information from one row at a time to another sheet 1
Excel VBA 1
Comparing numbers 1
comparing two columns in vba 2
Excel 2007 Like or Contains Expression 2

Back
Top