Help with Baseball Formula
 

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 C2C4 then G2=B2
and of course
if Score in cell C4C2 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

Help with Baseball Formula
 

in cell B2 put the following:
=if(C2C4,G2,G4)

--
JNW


"KLB" wrote:

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 C2C4 then G2=B2
and of course
if Score in cell C4C2 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

Help with Baseball Formula
 

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

"KLB" wrote:

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 C2C4 then G2=B2
and of course
if Score in cell C4C2 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

Help with Baseball Formula
 

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(C4C2,A2,"")

"KLB" wrote:

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 C2C4 then G2=B2
and of course
if Score in cell C4C2 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

Help with Baseball Formula
 

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(B5B7,1,0) then I hid the results by using white font
B7 says =IF(B7B5,1,0) then I hid the results by using white font

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

J5 says =IF(I4I6,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.

Help with Baseball Formula
 

Wow. that turned out to be a mess

Sorry

How about if I just put it:

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

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

J5 says =IF(I4I6,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

Help with Baseball Formula
 

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

baseball standings excel file
 

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

baseball standings excel file
 

To whom or to which posting is this post addressed?


Gord Dibben MS Excel MVP

On Tue, 25 Sep 2007 10:50:03 -0700, Lina M wrote:

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

baseball standings excel file
 

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 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!
--
David Biddulph

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
To whom or to which posting is this post addressed?

Gord Dibben MS Excel MVP

On Tue, 25 Sep 2007 10:50:03 -0700, Lina M wrote:

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