Comparing Data [Closed]

Report
Posts
2
Registration date
Sunday May 26, 2013
Status
Member
Last seen
May 27, 2013
-
I need to compare data in one column to that in multiple other columns to find missing data. Column "A" is static data, and can be entered into any cell in any row in columns "N" through "X". I would like the specific data cell in column "A" filled red to indicate it does not appear in any row of any column "N" through "X".

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!