compare/match data in excel 2013
Posted on 2014-09-22
I need to know how I can match data in two columns in excel 2013. I need it to say like TRUE or False.
I tried to follow the below formula (found it on internet), but im still struggling to understand this. Can someone please give me a simple and easy to follow formula or create me a template where I can copy data into, or if possible a VB script ( I am complete novice when it comes to excel). Please can someone put in steps for me?
"Conditional format-> Add new rule->Set your own formula:
Where A2 is the first element in column A to be compared and B is the column where A's element will be searched.
Once you have set the formula and picked the format, apply this rule to all elements in the column."