I have been trying with little success to compare four columns containing url results to a golden list in excel.
I want to count all the matches in each column and give a running total per set. I have used VLOOKUP, Match and highlight duplicates none seem to be able to give the desired effect
Golden list Column A Column B Column C Column D
I want it to compare the values in the golden list against the other 4 columns and give a score count of all exact matches found. I have read several of the Excel Stack Overflow questions and used youtube with no luck so far.
Computing score for each item in golden list is as easy as:
To get the score for each column you can either:
For the second approach, you can use
=IF(ISNUMBER(MATCH(...)), 1, 0) approach - if you have duplicated links in columns, or a simpler formula if they are unique:
..and then sum it all up for each column, as illustrated by following picture: