I ned help, I am trying to create a volleyball stat sheet in excel. The left
col lists the girls names and number, and across the top row is the list of
stats we want to track. For example col. a is blocks I want to enter the
girls number in the block cell and excel will then add 1 to that girls block
col. and when I enter her number again excel will add 1 more so now she will
have 2 blocks

If ace=16,(b2+1)if ace=5,(b4+1) and so on. There are 8 girls and 7 stats if
I enter that number again then excel will than add 1 so now the girl would
have 2 ace Thanks for your help

Ace Block Digs Kills
Service Error Drops Return Er
16 21 5 9

AT 16 1

BG 5 1

JG 9 1

JL 8

MS 11

SC 23

SG 21 1