Function @ IF, INDEX, AGGREGATE, LARGE, and COUNT

Ryles_98 

Sigh.....

I'm sorry that your usual go-to person isn't available any more. That's sad on many levels; I pray, first, that he or she has gone to a better place.

Second, though, this is a classic case of a system needing some user documentation, both on how to use AND (equally important) what all the formulas are for, how the overall system works.

To come in cold and figure out even what the big picture is is complex enough. I'm attaching the Excel spreadsheet here, with the hope that perhaps some others more skilled at "reverse engineering" can apply that kind of magic.

You can help those others, and me, by:

• Describing the "big picture" -- you've replaced the real names (of schools?) with letters in this, but the real names were there in the image, so although that was thoughtful of you, it was kind of closing the barn door after the horse had escaped. That said: I'm assuming this is a tally sheet for the result of team competitions between schools, perhaps a set of debate teams or some such. But the more you can tell us, still maintaining confidentiality of the who and where, the better.
• In the course of describing that "big picture", what do the various entries, the "names," the numbers to the third decimal place, etc., represent?
• What's the relationship between data on Sheet1 and data on Sheet2? Is one the more "raw data"? Which?
• Your spreadsheet, without names, only with letters, appears just to run from A to ZZZZZ, with no repeat names; but I assume that in the real world, the teams repeat. I.e., Team AAA may meet different opposition in each of the different rounds, but team AAA appears in every round,  always representing Central High School [or whatever] in Springfield, MO [or wherever].
  • If that's the case, then doesn't the version you posted present a data-integrity problem, in that there's no way to track the performance of team AAA through all the rounds.
  • If it's not the case, then please describe more thoroughly what we are to make of the scrambled sets of letters? Or do they have no real meaning at all?

I could go on, but I think you get the idea. If we were sitting down face-to-face, I'd be asking a lot of questions. Anticipate those questions, realize this needs a lot of explaining, and--even though you're in the middle here, maybe not even being the original creator of this, what would you be telling us about what it is, how it is intended to work, what the different areas of the workbook are for, and so on....