I have all 30 hockey teamas liste in colum A, I want to record each
particpatnts picks for the game in colums B-? (depenging on # in pool)
(was using =a1 etc) then I want to delete  the team that lost leaving
the winning teams showing. This way it is easier for me to calculate
the person who has the most right. But when I delete the team from
Colum A I get zeros in the cell  where I had the =a1.
Does this make any more sense? I could save the spread shette as
html and post the link so ou can see what I am doing.