Glad you got it all working.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"damanwitdaplan" wrote in message
...
Thanks again! They work great! You saved the day for me!

"Sandy Mann" wrote:

Yes, you should be able to just substitute the cell reference for the
Team
name:

=IF(AND(AA16<"",AA30<""),IF(MAX(AA16,AA30)=AA16, "Team #1",I20),"")

=IF(C38="","",IF(B38="Team #1",I20,"Team #1"))

If you also enter the name of Team#1 in a cell - say I21 the you can use
both references:

=IF(AND(AA16<"",AA30<""),IF(MAX(AA16,AA30)=AA16, I21,I20),"")

=IF(C38="","",IF(B38=I21,I20,I21))


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"damanwitdaplan" wrote in
message
...
Ahh man. Just when you thought you were done.

Turns out that 'Team #1' is fine. However my friend now needs 'Team #2'
in
the formula to be the text in I20.

Is there anyway we can edit those 2 formulas so that instead of 'Team
#2'
it
is whatever is typed into I20?

"Sandy Mann" wrote:

Try: for B38:

=IF(AND(AA16<"",AA30<""),IF(MAX(AA16,AA30)=AA16, "Team #1","Team
#2"),"")

For B39 try:

=IF(C38="","",IF(B38="Team #1","Team #2","Team #1"))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"damanwitdaplan" wrote in
message
...
I have a scoresheet I am trying to compile for someone. I ran it
through
like
it was a real time match and these are the results. This is what I
have
right
now.

In B5 I have 'Team #1'
And in C5 I have 'Team #2'

Team #1
(AA12:AB12) 150
(AA13:AB13) 30
(AA14:AB14) 20

Team #2
(AA24:AB24) 70
(AA25:AB25) 60
(AA26:AB26) -10
(AA27:AB27) 20
(AA28:AB28) 10

In AA16:AB16 I have the SUM of AA12:AB14
In AA30:AB30 I have the SUM of AA24:AB28

I need the results to appear like this

A38 B38 C38
1st place team Team #1 190

A39 B39 C39
2nd place team Team #2 150

Right now I have C38 as =MAXA(AA16, AA30)
And C39 as =MIN(AA16, AA30)

But in B38 I would like the text 'Team #1' to automatically appear
when
C38
has the higher amount. And in B39 I would also like the text 'Team
#2'
to
appear automatically when C39 has the lower amount.

Can anybody help me or is this just too hard?