Discussion Re: Formula or replace text in Excel
https://techcommunity.microsoft.com/t5/excel/formula-or-replace-text/m-p/3382977#M146645
Oh dear that didn't cut n paste very well the "Finish position last start" got shifted way over to the left sorryMon, 16 May 2022 19:32:39 GMTCharlie_Tango2022-05-16T19:32:39ZFormula or replace text
https://techcommunity.microsoft.com/t5/excel/formula-or-replace-text/m-p/3382953#M146643
<P>Good Morning, have been bashing my head for 2 hours trying to work this project out & not getting anywhere.</P><TABLE width="636"><TBODY><TR><TD width="80"> </TD><TD width="111">ASSESSMENT</TD><TD width="64">32</TD><TD width="64">10</TD><TD width="64">5</TD><TD width="100">33</TD><TD width="80">23</TD><TD width="73">18</TD></TR><TR><TD>Track</TD><TD>Horse</TD><TD> Days Since Last start</TD><TD> Finish Position last Start</TD></TR><TR><TD> </TD><TD> </TD><TD>< 10</TD><TD>11 > 15</TD><TD>16 > 30</TD><TD>Won by 3L +</TD><TD>Won by < 3L</TD><TD>2nd or 3rd</TD></TR><TR><TD>KENT</TD><TD>Red Rum</TD><TD>bb</TD><TD> </TD><TD> </TD><TD> </TD><TD>cc</TD><TD> </TD></TR></TBODY></TABLE><P>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.</P><P>What's the simplest way to speed this up please?</P><P>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?</P><P>Many thanks</P><P> </P>Mon, 16 May 2022 19:29:16 GMThttps://techcommunity.microsoft.com/t5/excel/formula-or-replace-text/m-p/3382953#M146643Charlie_Tango2022-05-16T19:29:16ZRe: Formula or replace text
https://techcommunity.microsoft.com/t5/excel/formula-or-replace-text/m-p/3382977#M146645
Oh dear that didn't cut n paste very well the "Finish position last start" got shifted way over to the left sorryMon, 16 May 2022 19:32:39 GMThttps://techcommunity.microsoft.com/t5/excel/formula-or-replace-text/m-p/3382977#M146645Charlie_Tango2022-05-16T19:32:39Z