Formula to extract SCORES over 100 from each location of an individual Player (DARTS)

[Bruce54]

This may very well be just too big, but here goes ...

I've been handed a DARTS SCORE Sheet for a full LEAGUE
The owners want to record each time all players score over 99 (>=100)

The problem is multipartite:

• There are 6 players on the Team
• Each player can play in up to 3 "games" (TEAMS, DOUBLES, SINGLES) a night
• The required scores are from 100 - 180 (80 scores)
• The scores above 99 need to be listed against the relevant player and indicate any multiple hits:
  • Chris: 100 x 3, 101 x 1, 125 x 6 ...
  • Greg: 120 x 1, 180 x 2 ...
  • Laura: ...
  • Brian: ...

I'm guessing this will require multiple array formulae, of which I am only partially familiar.
There is probably far more to this problem than that, but it should indicate a direction.

Example 1.
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"]Chris[/TD]
[TD="align: center"]Greg[/TD]
[TD="align: center"]Laura[/TD]
[TD="align: center"]Brian[/TD]
[/TR]
[TR]
[TD="align: center"]40[/TD]
[TD="align: center"]120[/TD]
[TD="align: center"]68[/TD]
[TD="align: center"]102[/TD]
[/TR]
[TR]
[TD="align: center"]125[/TD]
[TD="align: center"]99[/TD]
[TD="align: center"]102[/TD]
[TD="align: center"]66[/TD]
[/TR]
[TR]
[TD="align: center"]180[/TD]
[TD="align: center"]144[/TD]
[TD="align: center"]75[/TD]
[TD="align: center"]110[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

to further complicate the problem, this "game" has 4 players, taking turns whereas
in the next "game" (Doubles) they play up to 3 times (best of 3 legs)
this also occurs in the SINGLES game where each individual player has 3 legs to negotiate.

I identified 12 ranges that need to be "handled"

• TEAMS1, TEAMS2, TEAMS3 & TEAMS4
• DOUBLES1 - 4 (Even though there are 3 legs, the whole 3 can be treated as a range belonging to that player)
• SINGLES1 - 4 (as Above)

I'd like to thank you for at least reading this. Needless to say, any help, or even a direction, would be beneficial

Yours

in anticipation

Bruce54