Hi fabulous Excel gurus,
I made a sample spreadsheet for you guys to display my problem.
BACKGROUND:
I have a spreadsheet where we keep track of meetings done with counter parties. As more meetings happen, more data will be enter. Right now I put sample data in the first two counter parties, but in reality we have done meetings with them all and data will be in each.
WHAT IM TRYING TO DO:
I am trying to get the top part A4:J12 to keep track of the the meetings each person has been attending. The formula in my mind would have to look up if the Employee's name is in Firm Attendance under each of the counter parties....
PROBLEM:
Do to the various lookup ranges for Firm Attendance, and incorporating a counter to count, and the fact that all the names are stored in a single cell rather than there own, I am totally lost on how to do this....
FYI - If it is impossible to look up a single name in a cell containing multiple names like this below
Jacob Smith
John Doe
Henry Henricks
Dustin Katz
Than what do you suggest I do?
Any help out there?
Bookmarks