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.

Chris	Greg	Laura	Brian
40	120	68	102
125	99	102	66
180	144	75	110

<tbody>
</tbody>

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