Oh thats great. Glad it worked.
I have just put 2 simple examples on the thread to deal with the first of the three parts. Instead of applying to your spreadsheet, can you just confirm on the thread, if one of those is the same thinking as yours.
We can then deal with the second part.
I am not sure if youy are trying to include part 2 and 3 in the same formula as part1 or not. Or are you putting each one in a seperate cell.
Anyway, if we can at least fix the goalpost for the first part, I think we are then on our way.
Separate names with a comma.