Saturday, 23 March 2013

Excel column matching

If there are 200 cells are in ColA and 150 cells are in ColB, then at
C1 put the formula
=MATCH(A1,$B$1:$B$150,0)
and copy down to C200.

The cells in ColC that return #NA indicate the missing entries 

No comments:

Post a Comment