Comparing values to determine point which one value is greater and ends further comparison

Try

in T3

=IFERROR(INDEX($B3:$S3,MATCH(1,IF(TRIM(LEFT($B3:$S3,FIND("&",$B3:$S3)-2))+0>18-$B$2:$S$2,$B3:$S3,0))+1),"")

..confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Then copy down

OR


with SCORES ONLY in the cells:

in T2

=IFERROR(INDEX($B2:$S2,MATCH(1,IF($B2:$S2>18-$B$1:$S$1,$B2:$S2,0))+1) &" & "&18-(MATCH(1,IF($B2:$S2>18-$B$1:$S$1,$B2:$S2,0))+1),"")

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.


THEN copy down

See Sheet2

Does the attached help.

When analysing numerical data it simplifies things immensely if you create a regular normailised database that contains the underlying numbers. Your current table is essentially strings of text. You can derive string slicing formulae to convert them to numbers but it just makes life so much more difficult.

I've added a new sheet called Data. Here in columns B:E you'd add the round data. Columns F&G are formulae.

The summary table is in columns I:M.

I've only entered two matches but you'll see the general idea