Hi there..

I have two sets of data side by side in one worksheet. All the same
fields but one set of data has the more records than the other.

My aims is to display only the records that existing in each set.

I'm pretty crap when it comes to excel and so I'm not sure what kind
of formula I'm looking for here. vlookup? ISNA? MATCH?

I have done this =IF(ISNA(MATCH(M2,B:B, 0)),"NOT", " Found") which
tells me correctly that one is not in the other (and then I did it
again for the other side)

But what I actually just want to see is two sets of data with the same
number of rows.


Can anyone help me out here?