Problem with a formula - Calculating a place value

I have a spread sheet that was originally received from another person a few years ago. It is set up to calculate scores for contestants for 5 different judges in two main categories that each have 5 sections.

The over all score from each judge goes into the first section (photo) for each contestant, the scores are then totaled. The over all score from the each judge goes into the second section (stage) for each contestant, the scores are then totaled. The spread sheet has a column that says "If tie use photo score". I was playing with some numbers and found that when it pulls the numbers from the Photo Total column - it puts them in Value Order from Highest to Lowest, but they do not coincide with the contestant listed next to the number. This is the formula that is used: =LARGE(I$5:I$23,1) With "I" being the photo column.

What would be perfect is if it would look at the photo total and decide what place the contestant has place, based on if there was a tie. I checked the photo total scores against the "If Tie Photo" scores and they were not right. The values were right as far as highest to lowest, but were the wrong scores for the contestants them selves.

I know there is another column that is wrong, but I have to really look at what that is.

I would appreciate any help on this.

Thank you

Mari

Sorry for some of the original wording for this - I did this very early in the am.

First, your title description is too vague. I'm surprised an admin has not asked you to change it to something more descriptive. It would help drive more viewers to your issue if it is clearly stated.

Second, while I believe people can generally understand your problem, providing a solution is difficult. We generally like to provide exact solutions, and for this problem, you should attach your spreadsheet. As for now, I can only state that it sounds like you should use VLOOKUP to match the contestant with their photo score.

Okay, I think I understand your goal. You are correct in that column T is not tied to the girl on that line, but I think their intent was that it be tied to the girl in column W. As you noticed, the formula is flawed.

I think I solved this with some math rather than logic. First, you can ignore column T. It also had an error in it since the range was sometimes I$5:I$23 an sometimes I$6:I$23. It should always be I$5:I$23. Regardless, the intent, as I see it, is to use the sum of the scores as the first determinant, and in the event of a tie, to use the photo score. What I did was change the formula in R5 to
=I5+Q5+I5/100
This should have the same net effect, and the rest of the spreadsheet should now work.

Note, however, that in the event of a tie even with the secondary test of checking the photo score, the end results will show a double entry for the first girl with that score. This is because of how VLOOKUP works, and there are many posts trying to work around that issue. Maybe it is unlikely in your environment, though.

I'm not sure what you want. Didn't my suggestion to change the equation in column R (which is S in the new attachment) fix the issue? I assumed the scores were up to 10, but it looks like they can go to 50. So, instead of dividing by 100, divide by 1000. So, on the new sheet in S5:
=I5+R5+I5/1000
then drag that forumla down the column.