comparing columns of data
 

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.
--
Regards,
Dave


"john mcmichael" wrote:

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