On May 10, 10:46*am, "T. Valko" wrote:
'585','20','592','20','595','30','599','38','0',' 0'

What's the "rule" that differentiates the "X" values from the scores?

Just looking at the values, the scores are significantly higher than the "X"
values. If you can define a "rule" to separate the 2 then this can be done
with a relatively simple formula, otherwise, it'll be slightly more
complicated.

For example, sum the highest 3 values that are greater than 50 (highest
possible "X" value ???).


The scores are from a bullseye type target with a decimal
(10,9,8,7,6,5) scoring system. The highest possible value for any
individual shot is '10'. Inside the 10-ring is another scoring ring,
the 'X' ring. Any hit in the X ring still counts as 10 points, but
also counts as a tie-breaker. So ten shots all in the 10 ring but
with only seven inside the X ring would be noted as '100-7X'. A
100-1X beats a 99-9X, because the highest point value wins first, with
the X-count only coming into play in the event of a tie such as a
100-7X vs a 100-5X. Several individual stages add up to a daily
aggregate like the '595-30X' mentioned earlier. The high three daily
aggs out of five possible events (competitors may attend any or all of
these qualifiers) are added up, plus the daily score from the one
required event, and forms a grand aggregate for league champion, etc.

Don't know if that makes it any clearer or not ;) Its something that
is relatively easy, but time consuming, to do by way of Mk1 Mod0
eyeball (the sorting/filtering) but a bit more challenging to make
happen in Excel (so far).

Thanks,

Monte