comparing columns of data

J

john mcmichael

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
 
D

David Billigmeier

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