I run a weekly competition and I record the results as below
I would like to add a column counting how many times each participant wins the comp. How do I do this?
ie
Code:
Week1 Week2 Week3 Week4
Alan 50 100 50
Brian 30
Charlie 30 50 12 90
David 18
Ed 20 40 30
George
I would like to add a column counting how many times each participant wins the comp. How do I do this?
ie
Code:
Alan 2
Brian 0
Charlie 1
David 0
Ed 1
George 0