When the fishing tournament starts, all the names of the competetors (Leden) en their seat (zitplaatsen) can be selected from a list and are being automatically filled in in the corresponding cells. After the tournament is finished the weight of the fish has to be filled in in 2 columns. One column for the kgs and one row for the grs. With the SORT formula the data are being sorted from high to low. The one who cathed the most fish is obviousely the winner of the tournament. So far, no problem. The problem starts here:when 2 or more competetors catch the same amount (weight) of fish, the data has to be re-evaluated; the one in seat 2, for instance, wins from the one in seat 3 (so the higher the number of the seat, the lower you get ranked). This is also for instance for seats 14,17 and 18; if there weight is the same, number 14 is higher ranked then 17 and 18. Seat 18 is then lower ranked than 17. The reason herefor is that when they start to weigh the fish, they start at seat 1. The net is clean then. After 1 they weigh 2, then 3 and so on...The further they go, the more algue they collect in the net, that is being weighted also, but is no fish. So the last seat has a lot of weight that includes fish and much algue.

Please, can someone help me integrate the correction in the spreadsheet ?

• Hi. Your spreadsheet requires permission to gain access - that's a disincentive to help with your question. Make sure that you don't include any private or sensitive data, and then share it with anyone with the url. You can stop people making changes to your spreadsheet by following the answer in this Q&A How do I share a Google Sheet with 'read only' permissions? - this enables a volunteer to open your spreadsheet and then make a copy for their own use. Commented Aug 2, 2022 at 9:55
• Hello, I replaced the Sheet (with adapted permissions) by this one: docs.google.com/spreadsheets/d/… Commented Aug 3, 2022 at 15:33

Create the sorted results using a query. This query is located in the same sheet as the raw data, but the query can be created on any sheets (such as the Results Sheet).

Locations using decimal points

`={query({"Result";A10:A27}),query(B9:F27,"select * order by C desc, D desc, E asc")}`

Locations using decimal commas

`={query({"Result";A10:A27})\query(B9:F27;"select * order by C desc, D desc, E asc")}`

NOTE: Avoid merging rows and columns in the sheet containing the raw results. This can cause unexpected results.

Sample

• Can you please explain the formula, because I get an error when I use this formula. Commented Aug 12, 2022 at 5:49
• My apologies. Your locale was Netherlands (Decimal comma) but I am in Australia (Decimal point) and I developed the answer using the Australian locale AND I forgot to change the Locale back to Netherlands. I've updated the answer to show the formula for both Locale options. Just try the one for "Decimal Commas". Commented Aug 12, 2022 at 6:14

is this what the formula you're trying to use:

`=sort(A3:C8,2,false,3,false,1,true)`

BEFORE/AFTER

`SORT` Documentation