I have a small desire with my football table...

I want to sort automatically range EC35:EL49 by COLUMN EF (OBP) which is FIRST priority and when the participants are on equal points by COLUMN EF (OBP), then sort by column EH (MS) and when participants are still on equal points by COLUMN EH (MS), then sort finally by column EJ (MBP).

Is it possible?

I have a code in apps script but this sorts only by column EF.

Thanks in advance!

Table link:

Note
Unhide the columns to see the full input and output on your sheet.

CodePudding user response：

Is it possible to do it with App Script and without unhiding columns?