comparing columns of data

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

Guest

Is there an easy way to compare two columns of data to see what is common
between them. For instance, I wanted to compare the first column in each of
the three tabs to see which cells are identical between them
 
If the values are on the same row you can just use an equals sign, i.e.
"=A1=B1" will return TRUE if A1 equals B1 and FALSE otherwise.

Otherwise take a look at VLOOKUP(), HLOOKUP() or MATCH() in the help menu
for locating values within a range.
 
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
Question about Comparing Data 1
Comparing Text between Columns 6
Comparing Two Columns of Data 6
Comparing two spreadsheets 2
comparing columns in two spreadsheets 1
Comparing 3 Columns 2
COMPARING TWO COLUMNS OF INFORMATION, ACROSS TWO WORKSHEETS 2

Back
Top