I have a list of names in column K, and letters in columns L-M.
The name appears multiple times in column k, I would like to know the sum of letters against each name for col L-K
e.g
My name | A, B, C, D
Your name| A, C
My name| A, D
Your name| A, B, C, D
thanks
Lee