I am using Microsoft Office 2010. I have 5 worksheets.
Worksheet 1: Provided Worksheet 2: WL Tool Summary Worksheet 3: Salesforce Worksheet 4: Pipeline Worksheet 5: Combined
Typically, I get a list of 20+ names. I copy and paste those 20+ names in the provided tab.
Then I pull names from WL Tool Summary. I copy and paste 30+ names into that worksheet.
Same thing with Salesforce/Pipline.
Then I change the color of each text in each worksheet: so provided could be blue, WL tool could be green etc. I copy all the tabs into combined and I look for matches.
I know there is a way to have excel compare these values for me and spit out the result in the "Combined" tab. I tried to write the formula myself but it didn't work
Any help would be appreciated