7th August 2006, 03:52 PM
|
|
Member
|
|
Join Date: Jan 1970
Location: Sydney
Posts: 402
|
|
Quote:
|
Originally Posted by Twodogs
Good Afternoon
Can anyone help with following? I have searched for an answer but it is beyond my knowledge unfortunately.
I have this data in one column which is the winning distances and the number of times they have won at that distance 1(1000) 1(1200) 1(1300) 1(1450) 1(1550)
In a second column I have the distance of todays race 1000
In a third column I would like have a yes or no for the following. The horses winning distance range from the above data is 1000-1550 and it is contesting a 1000m race so that would be a yes as it fits within the the horses winning distance range. Of course if todays race was 1800m it would be a no.
I do have a column that JFC helped me with which could be used if it is easier which just has the winning distance range.
Thanks
Twodogs
|
TwoDogs,
Originally you asked for something to produce a column like :
1300-3200
But that is not very useful.
Instead you probably need to get the 1300 alone in one column and 3200 in the next.
So try and do that by pulling apart that long-winded answer I gave you.
Then if
B = today's distance
C = minimum winning distance
D = maximum winning distance
Enter this into E
=IF(AND(B1>=C1,B1<=D1),"yes","no")
|