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.

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

actually just meddling with some ratings today with no races on :(

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.

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

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;))

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.

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?

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..

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 :)

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?