Write a excel function or BV code for excel to get summary
I want to want to learn excel formula or BV code where I will assign team members name in a table and in other table team remembers name will come as summary as attached image. enter image description here