Hi
I've looked online for help but not having any joy with exactly my problem which I am now tackling a different way.
I am trying to match candidate names and then also count how many of them (ie. matched candidates only) have a score of e.g. >1
I can match the candidates but am struggling to do a count of how many have a score of e.g. >1 because I am comparing 3 columns.
So I need to match the WHARFEDALE candidates with the AIREDALE candidates first, and then I need to count how many of the WHARFEDALE candidates have a score >1 AND/OR how many AIREDALE candidates have a score >1. The AIREDALE candiates get 2 'tries' so a score >1 in either try will add to the counter. I DON'T need a score >1 in all three columns D, I, K. Only a score >1 in D + score >1 in EITHER column I, K. Also don't need a repeat count if score is >1 in all three columns D,I,K.
Could somebody let me know if there is an easy way of doing this in Excel .... my file is attached.
TIA
Bookmarks