Search results

That's basically it, except it needs to sort for scratches first, then time. Thanks Hui!

Hmm, OK, I see your point. To clarify though, I'm not just using the 'Data > Sort' option in Excel. I'm writing the functions so that everything sorts in real time. So what I need help with is choosing the right combinations of functions so it automatically sorts as I enter the data into the...

Opposite. First sort by scratches, and then by times.

I've successfully created sheets that can sort values, but I'm absolutely stumped when I add another layer to hierarchy. Here's the deal: I'm running an obstacle event and, simply put, I need the scoresheet to sort for the fastest times. The tricky part, though, is that the times are scratch...

Still off. The samples I'm using to check the work are A.) competitors 23-25, and B.) Competitors 12 & 22. Manually checking A should yield 23 & 25 finishing tied for 2nd, and 24 finishing 4th. In B, 12 should finish 6th and 22 should finish 7th.

@NARAYANK... Yeah, I have a hard time making sense of it, but it does appear to be on track. That said, I know that the instances of ties are not sorting correctly. Thanks for trying though.

Thanks Faseeh. The lower table (green rows) is where data is entered for the success and failure of each attempt. The "Scoring" table's functions are written. Those don't need to me altered. The "Sorting" table, and particularly the column highlighted in purple, is what I'm trying to write the...

I love this site and have taught myself a great deal from everything I've read here, but I'm now stuck with a very difficult problem that I feel is beyond my expertise. It's the last piece in a large puzzle, and it's the hardest piece! I need help writing the formula will calculate comparative...