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.
 
Back
Top