Number of runners in Excel?
Moderator: 2020vision
5 posts
• Page 1 of 1
Number of runners in Excel?
by marin71 » Wed Nov 07, 2007 4:02 pm
Is there a way to get the numbers of runners which is now displayed in the latest beta into the excel sheet?
- marin71
- Posts: 43
- Joined: Fri Sep 29, 2006 3:16 pm
by GaryRussell » Wed Nov 07, 2007 4:14 pm
Not currently, it's on our list of suggestions and will be implemented in a week or so.
-
GaryRussell - Site Admin
- Posts: 9871
- Joined: Fri Nov 18, 2005 8:09 pm
- Location: Birmingham, UK
by alesh » Wed Nov 07, 2007 6:27 pm
In italian: =31-CONTA.SE(A5:A35;"")
In english I think: =31-COUNTIF(A5:A35;"")
(you can change 31 and A35..)
Sorry if it's wrong..
In english I think: =31-COUNTIF(A5:A35;"")
(you can change 31 and A35..)
Sorry if it's wrong..
- alesh
- Posts: 7
- Joined: Wed Mar 22, 2006 3:15 pm
by marin71 » Tue Nov 27, 2007 1:15 pm
Hi Gary,
any news when this will be implemented?
Cheers Markus
any news when this will be implemented?
Cheers Markus
- marin71
- Posts: 43
- Joined: Fri Sep 29, 2006 3:16 pm
by phrenetic » Tue Nov 27, 2007 2:36 pm
To get the number of runners, I always use:
=COUNTA($A$5:$A$44) - COUNTIF($A$5:$A$44,"-")
because in the American horse racing markets, non-runners are indicated by a dash ("-") on BA.
Alistair
=COUNTA($A$5:$A$44) - COUNTIF($A$5:$A$44,"-")
because in the American horse racing markets, non-runners are indicated by a dash ("-") on BA.
Alistair
- phrenetic
- Posts: 142
- Joined: Tue Oct 16, 2007 8:44 pm
5 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 49 guests