Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 15th May 2012, 05:54 PM
moeee moeee is offline
Suspended
 
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
Default Excel Help needed

What I wish to do is for a Star to appear in Column E if the animal is Ranked 6th to 8th
I will manipulate the Data and the animals may change their ranking.

When I have done with the worst Ranked animal I will clear its D Cell.
Then I wish Column E to ignore the worst animal and put a Star in the 5th to 7th worst animals.
I was hoping that Column E would automatically ignore the D Cell if it was empty.
Attached Files
File Type: xls Dogs.xls (66.0 KB, 438 views)
Reply With Quote
  #2  
Old 15th May 2012, 07:12 PM
woof43 woof43 is offline
Member
 
Join Date: Jan 1970
Posts: 696
Default

will column C always stay the same Moee?,
You could use conditional formatting to highlight with say red traffic lights or Flags for 6-8 and 5th could be a yellow traffic light and green for the rest of the field, based on the ranking in column C
Reply With Quote
  #3  
Old 15th May 2012, 07:27 PM
moeee moeee is offline
Suspended
 
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
Default

Hi Woof43

Column C is the current assessed Odds
They will change as I manipulate my data.
What I wish to do is concentrate on the 3 worst animals and have a separate Market based only with these 3 animals in it.

What I need is something like =If(D>(Count(D1 : D8)-3),"","*") or maybe =If(D>(Count(C1:C8)-3),"","*")

When I have the worst ranked animal at the Odds I believe it should be , then I wish to eliminate it from the Rankings.

Last edited by moeee : 15th May 2012 at 07:29 PM.
Reply With Quote
  #4  
Old 15th May 2012, 07:35 PM
woof43 woof43 is offline
Member
 
Join Date: Jan 1970
Posts: 696
Default

would it be better to keep your original data, then create your new markets in adjacent cells based on whatever criteria, so you can see your changes

PS that #1 in that race is about 1.70 chance of leading.
Reply With Quote
  #5  
Old 15th May 2012, 07:37 PM
moeee moeee is offline
Suspended
 
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
Default

Quote:
Originally Posted by moeee
What I need is something like =If(D>(Count(D1 : D8)-3),"","*") or maybe =If(D>(Count(C1:C8)-3),"","*")


Okay everyone
I'm good.

=IF(D1>(COUNT(D$1 : D$8)-3),"*","")
Reply With Quote
  #6  
Old 15th May 2012, 07:42 PM
moeee moeee is offline
Suspended
 
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
Default

Quote:
Originally Posted by woof43
would it be better to keep your original data, then create your new markets in adjacent cells based on whatever criteria, so you can see your changes

PS that #1 in that race is about 1.70 chance of leading.


Yes.
What you are saying is pretty much what I am doing.

And i am well aware of the early speed of #1 and have taken it into account.
Its recent times at Geelong aren't nowhere near enough for it to be a Odds On Chance of winning.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 08:07 PM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655