General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
18 Jan 10
14:09
Joined:
Date Joined:
03 Sep 08
Hi - i want to count the number of races this season from a traditional formline e.g 006-111 (it's a Mark Prescott horse) would return 3
I can think of adding a column then use text to columns, delimited, using - as the delimiter
From the resulting column i can use =Len(a1) should give the correct result.
Is there a one-step solution?
On a subnote wouldnt it be better to denote a break of say 90 days. Now that we have all year round racing most often the numbers of runs into a traditional season is irrelevant for analysis.
I can think of adding a column then use text to columns, delimited, using - as the delimiter
From the resulting column i can use =Len(a1) should give the correct result.
Is there a one-step solution?
On a subnote wouldnt it be better to denote a break of say 90 days. Now that we have all year round racing most often the numbers of runs into a traditional season is irrelevant for analysis.
Show More
http://www.techonthenet.com/excel/formulas/find.php
(The find command) seems like you know what you're doing, and It's not a command I've used so I'll let you puzzle it out from there :D, pretty sure that with the correct +1 or -1 you'll get what you need.
(The find command) seems like you know what you're doing, and It's not a command I've used so I'll let you puzzle it out from there :D, pretty sure that with the correct +1 or -1 you'll get what you need.
Thanks, but i think not, because i want it to read right to left ....???
Maybe the example was not great being in the middle .. i would want 7089-25 to return as 2. Using FIND it would be 4
Maybe the example was not great being in the middle .. i would want 7089-25 to return as 2. Using FIND it would be 4
btw - Are you old enough to remember Lori and the Chameleons?
I don't remember them. According to Wiki I'm old enough though :p
Lori and The Chameleons - Touch, i'm listening to it now on Youtube, perfect slice of 80's electro-nonsense
Damn, now i'm browsing pop videos on Youtube. Thats the days work over....because I must look for Lucky Number by Lene Lovich ....
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539