comparing columns of data

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
 
G

Guest

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.
 

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 Two Columns of Data 6
comparing columns in two spreadsheets 1
Comparing two spreadsheets 2
COMPARING TWO COLUMNS OF INFORMATION, ACROSS TWO WORKSHEETS 2
Comparing sets of data, where criteria met, sum certain columns. 6
Comparing two lists using two columns from each spreadsheet 1

Top