I have 4 columns of data. I am trying to connect the Scores to the idNumbers.
Two sets of data. Column A and B are idNumber and Member names.
And Column C and D are Participants and their Scores.
The Participants are Members, but not all of the Members participated.
So, need a way to connect the Scores to the idNumbers by matching or sorting the Members and Participants.
I attached a small sample. The columns are actually 100's of members and participants long.
Ultimately, to create a weekly log of active Member's Scores.