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
  #11  
Old 6th April 2012, 11:29 AM
moeee moeee is offline
Suspended
 
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
Default

OMG NoRisk.
If I knew what you were talking about I figure I would have this situation sorted and not have had a Question to ask.

I do know how to record a Macro and then go ahead and cut and paste and select Sheets and stuff like that.
And then stop recording and then perhaps modify the Macro to do it precisely what I want.

The one item that I don't know how to put in a macro unless I edit is the For x= 1 to 100 type.I use this a lot.

But I have never tried doing Formulas , but I will try and see if the Formula is in the Recorded Macro after I type it in a cell whilst recording .



EDIT:
Just reread what you Posted
Made perfect sense this time.
I'll give that one a try.

Thanks buddy.

Last edited by moeee : 6th April 2012 at 11:32 AM.
Reply With Quote
  #12  
Old 6th April 2012, 11:45 AM
norisk norisk is offline
Member
 
Join Date: Dec 2011
Posts: 334
Default

lol, no probs moeee, if u get stuck repost & I will help out,

actually just meddling with some ratings today with no races on
Reply With Quote
  #13  
Old 6th April 2012, 12:17 PM
moeee moeee is offline
Suspended
 
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
Default

Nope.
Some people just have no idea

I need to combine 2 Formulas into one

The First Formula is
=IF($F1<>0,B1,C1)
And that is working except it ain't exactly what I want.

What I need to add is a further IF , but I keep getting an error
I try doing this.
=IF($F1<>0 then IF($G1<>0,B1,C1))

Its not an error in the Result but a Syntax Error.
Could it be I need to change the "then" into and "and"?

I'll go try that and if no Luck I'll wait for help.
Reply With Quote
  #14  
Old 6th April 2012, 01:10 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default

=IF($F1<>0,IF($G1<>0,B1,C1),"")
__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________
Reply With Quote
  #15  
Old 6th April 2012, 01:12 PM
norisk norisk is offline
Member
 
Join Date: Dec 2011
Posts: 334
Default

try this moeee, I added a couple of figures highlighted in yellow to get it working (assuming we are on the same page of course)
Attached Files
File Type: xls Meadows 5 (1).xls (586.0 KB, 394 views)
Reply With Quote
  #16  
Old 6th April 2012, 02:55 PM
moeee moeee is offline
Suspended
 
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
Default

Sort of so close NoRisk , but if I insert a Number into Cell G1 , then the duplicate Rows shouldn't change.
And the Reason they shouldn't change is because Cell F1 is a Blank Cell.
Whenever Cell F contains nothing , then that Row of Numbers needs to stay as it is.(Well it doesn't really , but thats another story which may be revealed once this Formula gets sorted out)


EDIT:
Also - If I insert a number into Cell G4 , then the number in K4 becomes a null and it should stay the same as it was.

Last edited by moeee : 6th April 2012 at 02:58 PM.
Reply With Quote
  #17  
Old 6th April 2012, 03:25 PM
norisk norisk is offline
Member
 
Join Date: Dec 2011
Posts: 334
Default

sounds highly complex moeee, & being on my second & aiming for my third beer probably wont help in finding a solution today

but just to clarify, you only enter a new rating in column F or G?
Reply With Quote
  #18  
Old 6th April 2012, 03:52 PM
woof43 woof43 is offline
Member
 
Join Date: Jan 1970
Posts: 696
Default

moee
excel isnt the proram for this, but anyway

add a column to your data that will have the formula countnumbers.

then apply conditional formatting so any row that has a 5 = (5 starts) will be formatted red, then add more formatting so that each of the cells with countnumbers are all different colours.

then sort the data using advanced filter , using colour as the filter so now will only have entrants wth 5 starts , then just create a macro to paste your new number, then copy and paste to another sheet
then repeat till you do done them all...then automate it into one macro..
Reply With Quote
  #19  
Old 6th April 2012, 04:27 PM
moeee moeee is offline
Suspended
 
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
Default

I know you have the answer Woof43.
And I appreciate you trying to help.
But as usual , you really may as well be talking in Chinese.
I can't even understand NoRisk, and at that stage I don't think he even cracked his first tinny.

The New data gets pasted into Column G NoRisk.

Then the Norisk Columns contents get pasted over the top of Columns B to F and then Column G is cleared.

And then we do it all again in 24 hours or so
Reply With Quote
  #20  
Old 6th April 2012, 04:37 PM
woof43 woof43 is offline
Member
 
Join Date: Jan 1970
Posts: 696
Default

thats ok,
the real crux i'm interested in is the ratings, are they are power type of ratings based on grade and finish.

There's a big difference between racing and dogs class /grade/power ratings

does'nt take much thought but in greyhounds if a dog progressed thru the grades by winning each start and was having it's next start in top grade, and then you had a dog that raced in top grade for 4 weeks and had run second each week, which dog should be on top in the power/grade ratings?
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 11:16 AM.


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