OK, I was able to play around with it and get the error to fixed, but now I h ave a new error in the very last set of tabulation ( overall highest score of all contestants). Also, if there a way to simplify the sheet?? Also, is there a formula to choose the next highest score if the same...
Ok I will try to explain further
I have atleast 13 age groups with contestants. The judges score based on 7 criteria, and one tie breaker criteria. Those scores are added together to detirmine the age group titles and 2 superlatives. I got the spreadsheet to add together ONE age group, and...
OK, if you havent already noticed, I need this for beauty pageants. I will have several contestants in different age groups that I will need the scores added up as I enter them. Then I will need to know, per age group, who ranks in that entire group, and also with in another group called a...
Ok, here is my problem. I am trying to create a spreadsheet to tabulate scores. I have got the basic adding formulas up and running. However, I need the sheet to lookthru a column on a specific number of cells, list them highest to lowest, list those in other column, and then display the name of...