Help with Baseball Formula

[KLB]

Hi, I am bit of a novice so please be gentle.

Would like to create a worksheet to keep track of Baseball Standings.

So if Score in cell C2>C4 then G2=B2
and of course
if Score in cell C4>C2 then B2=G4

Column C would have numeral scores
Columns B and G would have names of teams
If true team form Column B would advance to Column G

If you could please help me with this much I think I should be able to do
the rest.

Thank-you

 

[Guest]

in cell B2 put the following:
=if(C2>C4,G2,G4)

 

[Guest]

Hi KLB,
If I understand your requirement properly, there will be names of teams
which will be shifting from column B to G or vice versa depending on the
scores in C. The same name will be shifting places. If this is correct, you
can try the following:

i) Keep the name in Column A ( say A2)
ii) In B2, type =IF(C4<C2,A2,"")
iii) In G2, type =IF(C4<C2,A2,"")

This should meet your requirement.

But what I do not understand is how your data is structured. Will it have
only one name or several names. What will be there in Cell 3 of cols B and
G. What will be there in cols D and E and how you are using them. If you
can give a sample of the data, perhaps it can be seen whether the formulae
given above can be simply copied down the list.

Best Wishes

 

[Guest]

KLB
Sorry, there would be a correction. I think you want the name to shift to
G4 and not G2. In that case the second formula at Sl No. iii) should be
typed in G4 and not at G2:
=IF(C4>C2,A2,"")

 

[KLB]

Ok, thank you; this is working but would also like to extend formula to say
if I4=I6 then do not enter anything.in J5
I know it is not excatly what you sent me but your suggestion gave me a jump
start on the thinking.

A B C D E F G H I J
1 TEAM Game 1 Game 2 Game 3 Game 4 Game 5 Game 6 Game 7 Series Winner
2 Oct,24th Oct,25th Oct,27th Oct,28th Oct,29th Oct,31st Nov,1st
3
4 Philadelphia Phillies 1 0 0 0 0 0 0 1
5 1 0 0 0 0 0 0 Philadelphia Phillies
6 Team B 0 0 0 0 0 0 0 0
7 0 0 0 0 0 0 0



B5 says =IF(B5>B7,1,0) then I hid the results by using white font
B7 says =IF(B7>B5,1,0) then I hid the results by using white font

I4 says =SUM(B5:H5)
I6 says =SUM(B7:H7)

J5 says =IF(I4>I6,A4,A6)

Thank you
Hope I haven't broken any newsgroup protocols
Not advocating that the Phillies are going to win, just using their name for
spacing since it is the longest.

 

[KLB]

Wow. that turned out to be a mess

Sorry

How about if I just put it:

B5 says =IF(B5>B7,1,0) then I hid the results by using white font
B7 says =IF(B7>B5,1,0) then I hid the results by using white font

I4 says =SUM(B5:H5)
I6 says =SUM(B7:H7)

J5 says =IF(I4>I6,A4,A6)

would also like to extend formula to say
if I4=I6 then do not enter anything.in J5

Gee, talk about tongue-twisted, I feel like Porky-Pa-Pa-Pig

Thank you

 

[KLB]

Thanks to everyone who helped

I have completed my Post Season Baseball Schedule.

If anybody would like a copy please write me.

Thanks again
KLB

 

[Lina M]

I have a friend who is trying to set up an excel file to keep track of standings. Yours sounds like what he wants. If you are willing to share that file it would be greatly appreciated. I'm totally excel challenged so I'm no help at all!

Thanks,

Lina

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[Gord Dibben]

To whom or to which posting is this post addressed?


Gord Dibben MS Excel MVP

 

[David Biddulph]

According to the references line in the header, this is a reply to

Yet again, someone posting from EggHeadCafe with no idea of usenet protocol
or netiquette.
As well as needing to quote some relevant context, if folk are going to
change the subject line of a message they should at least leave in a
reference to the previous subject, along the lines of:
baseball standings excel file (was Re: Help with Baseball Formula)
but of course there was apparently no logic behind changing the subject line
at all.

Oh, I do wish that OE had a means of implementing a message rule to kill
posts from EggHeadCafe!