Tuesday, September 29, 2009

Excel formula - FIND MATCHES

Find matches from COLUMN 'A' with COLUMN 'B'
Pretty simple, yet hard to remember or easy to forget

Fill up COLUMN 'C' with the formula, the expected results:
All the matches found from A with B will display 'A' data on 'C'
If it's not found it will display NA (not available) message, which you can easily filter and work with.

Drink a coke while you do this as a reward.


Post a Comment