Good Morning, have been bashing my head for 2 hours trying to work this project out & not getting anywhere.
Days Since Last start
Finish Position last Start
11 > 15
16 > 30
Won by 3L +
Won by < 3L
2nd or 3rd
When entering a value for either C4 D4 or E4 in the example above can I enter any text, say bb, in the cell e.g lets say it was 8 days since Red Rum last competed so he gets assessed at 32 points. Then for my next criteria he won his last race by less than 3 lengths, I've put cc which gets him 23 points.
What's the simplest way to speed this up please?
Do I have to write a formula for each column or do I need to "replace text" so I end up with the numbers I want that will get totaled further along that row after assessing other criteria or am I just a bit dim & over-thinking this?