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?

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?

Thank you so much for your help!

But now I have yet another problem that has similar results.

I need the individual results too. So right now I have€¦

In A12 €œQuizzer #1€� and the results (points) of that quizzer in AA12.
In A13 €œQuizzer #2€� and the results of that quizzer in AA13.
In A14 €œQuizzer #3€� and the results of that quizzer in AA14
In A24 €œQuizzer #4€� and the results of that quizzer in AA24
In A25 €œQuizzer #5€� and the results of that quizzer in AA25
In A26 €œQuizzer #6€� and the results of that quizzer in AA26
In A 27 €œQuizzer #7, and the results of that quizzer in AA27
In A28 €œQuizzer #8€� and the results of that quizzer in AA28

Results
B42
B43
B44
B45
B46
B47
B48
B49

In C42 I have the following formula
=MAX(AA12:AB14,AA24:AB28)

In C43 I have
=LARGE((AA12:AB14,AA24:AB28),2)

In C44 I have
=LARGE((AA12:AB14,AA24:AB28),3)

And so on and so on. But I need the quizzers name (in text) with the
highest number of points to be displayed in B42. In other words€¦

Results
B C
42 Quizzer #4 145 points
43 Quizzer #2 70 points
44 Quizzer #7 55 points

And so on.

In other words, I have the C column figured out but I just need help with
the B column. Can anybody help me?

I assume that it may be possible for two Quizzers to have the same score so
you will have to ensure that no two score are exactly the same. The easiest
way of doing that is to enter in AB12:AB28, (or some other column if you are
already using that one), =AA12+ROW()/100000 and copy down to AB28 then hide
Column AB

B42 enter the formula:

=INDEX($A$12:$A$28,MATCH(LARGE($AB$12:$AB$28,ROW()-11),$AB$12:$AB$28,0))

Any tied scores will be listed in list order.

The results will list the Quizzers in nlist order untill enries are made in
AA12:AA28. If you want them to be blank untill all scores are entered the
enclose the formula in an IF() statement:

=IF(COUNT($AA$12:$AA$28)<17,"",INDEX($A$12:$A$28, MATCH(LARGE($AB$12:$AB$28,ROW()-11),$AB$12:$AB$28,0)))

--
HTH

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


with @tiscali.co.uk


"damanwitdaplan" wrote in message
...
Thank you so much for your help!

But now I have yet another problem that has similar results.

I need the individual results too. So right now I have.

In A12 "Quizzer #1" and the results (points) of that quizzer in AA12.
In A13 "Quizzer #2" and the results of that quizzer in AA13.
In A14 "Quizzer #3" and the results of that quizzer in AA14
In A24 "Quizzer #4" and the results of that quizzer in AA24
In A25 "Quizzer #5" and the results of that quizzer in AA25
In A26 "Quizzer #6" and the results of that quizzer in AA26
In A 27 "Quizzer #7, and the results of that quizzer in AA27
In A28 "Quizzer #8" and the results of that quizzer in AA28

Results
B42
B43
B44
B45
B46
B47
B48
B49

In C42 I have the following formula
=MAX(AA12:AB14,AA24:AB28)

In C43 I have
=LARGE((AA12:AB14,AA24:AB28),2)

In C44 I have
=LARGE((AA12:AB14,AA24:AB28),3)

And so on and so on. But I need the quizzer's name (in text) with the
highest number of points to be displayed in B42. In other words.

Results
B C
42 Quizzer #4 145 points
43 Quizzer #2 70 points
44 Quizzer #7 55 points

And so on.

In other words, I have the C column figured out but I just need help with
the B column. Can anybody help me?

"Sandy Mann" wrote in message
...

Any tied scores will be listed in list order.

Well my excuse is that I was being hassled by my wife to take her out
shopping. Shopping indeed!

No they won't! To get the tied scores in list order you will have to
SUBTRACT the ROW()/100000 not add it

=AA12-ROW()/100000 and copy down to AB28
--
HTH

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


with @tiscali.co.uk


"Sandy Mann" wrote in message
...
I assume that it may be possible for two Quizzers to have the same score so
you will have to ensure that no two score are exactly the same. The
easiest way of doing that is to enter in AB12:AB28, (or some other column
if you are already using that one), =AA12+ROW()/100000 and copy down to
AB28 then hide Column AB

B42 enter the formula:

=INDEX($A$12:$A$28,MATCH(LARGE($AB$12:$AB$28,ROW()-11),$AB$12:$AB$28,0))

Any tied scores will be listed in list order.

The results will list the Quizzers in nlist order untill enries are made
in AA12:AA28. If you want them to be blank untill all scores are entered
the enclose the formula in an IF() statement:

=IF(COUNT($AA$12:$AA$28)<17,"",INDEX($A$12:$A$28, MATCH(LARGE($AB$12:$AB$28,ROW()-11),$AB$12:$AB$28,0)))

--
HTH

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


with @tiscali.co.uk


"damanwitdaplan" wrote in
message ...
Thank you so much for your help!

But now I have yet another problem that has similar results.

I need the individual results too. So right now I have.

In A12 "Quizzer #1" and the results (points) of that quizzer in AA12.
In A13 "Quizzer #2" and the results of that quizzer in AA13.
In A14 "Quizzer #3" and the results of that quizzer in AA14
In A24 "Quizzer #4" and the results of that quizzer in AA24
In A25 "Quizzer #5" and the results of that quizzer in AA25
In A26 "Quizzer #6" and the results of that quizzer in AA26
In A 27 "Quizzer #7, and the results of that quizzer in AA27
In A28 "Quizzer #8" and the results of that quizzer in AA28

Results
B42
B43
B44
B45
B46
B47
B48
B49

In C42 I have the following formula
=MAX(AA12:AB14,AA24:AB28)

In C43 I have
=LARGE((AA12:AB14,AA24:AB28),2)

In C44 I have
=LARGE((AA12:AB14,AA24:AB28),3)

And so on and so on. But I need the quizzer's name (in text) with the
highest number of points to be displayed in B42. In other words.

Results
B C
42 Quizzer #4 145 points
43 Quizzer #2 70 points
44 Quizzer #7 55 points

And so on.

In other words, I have the C column figured out but I just need help with
the B column. Can anybody help me?

Okay, my computer just crashed so I had to adjust some things. Also my friend
said I need more quizzers on my sheet so I had to adjust some more things.

Here is another in-depth description of what I have so far.

A AA
12 Quizzer #1 110 [=SUM(B12:Z12)]
13 Quizzer #2 100 [=SUM(B13:Z13)]
14 Quizzer #3 90 [=SUM(B14:Z14)]
15 Quizzer #4 80 [=SUM(B15:Z15)]
16 Quizzer #5 70 [=SUM(B16:Z16)]

There is other text in A17:A25. There is the word €˜Total in A25

26 Quizzer #6 60 [=SUM(B26:Z26)]
27 Quizzer #7 50 [=SUM(B27:Z27)]
28 Quizzer #8 40 [=SUM(B28:Z28)]
29 Quizzer #9 30 [=SUM(B29:Z29)]
30 Quizzer #10 20 [=SUM(B30:Z30)]
31 Quizzer #11 10 [=SUM(B31:Z31)]

Text in A33. Otherwise none.

A B C
43 1st high scorer 110 [=MAX(AA12:AA16,AA26:AA31)]
44 2nd high scorer 100 [=LARGE((AA12:AA16,AA26:AA31),2)]
45 3rd high scorer 90 [=LARGE((AA12:AA16,AA26:AA31),3)]
46 4th high scorer 80 [=LARGE((AA12:AA16,AA26:AA31),4)]
47 5th high scorer 70 [=LARGE((AA12:AA16,AA26:AA31),5)]
48 6th high scorer 60 [=LARGE((AA12:AA16,AA26:AA31),6)]
49 7th high scorer 50 [=LARGE((AA12:AA16,AA26:AA31),7)]
50 8th high scorer 40 [=LARGE((AA12:AA16,AA26:AA31),8)]

So right now my problem is to get B43:B50 to work. I need B43 to be the name
of the high scorer (Quizzer#1) and B44 to be name 2nd high scorer (Quizzer
#2) and so on. Can anybody help me or is this one too tricky?


"Sandy Mann" wrote:


"Sandy Mann" wrote in message
...

Any tied scores will be listed in list order.

Well my excuse is that I was being hassled by my wife to take her out
shopping. Shopping indeed!

No they won't! To get the tied scores in list order you will have to
SUBTRACT the ROW()/100000 not add it

=AA12-ROW()/100000 and copy down to AB28
--
HTH

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


with @tiscali.co.uk


"Sandy Mann" wrote in message
...
I assume that it may be possible for two Quizzers to have the same score so
you will have to ensure that no two score are exactly the same. The
easiest way of doing that is to enter in AB12:AB28, (or some other column
if you are already using that one), =AA12+ROW()/100000 and copy down to
AB28 then hide Column AB

B42 enter the formula:

=INDEX($A$12:$A$28,MATCH(LARGE($AB$12:$AB$28,ROW()-11),$AB$12:$AB$28,0))

Any tied scores will be listed in list order.

The results will list the Quizzers in nlist order untill enries are made
in AA12:AA28. If you want them to be blank untill all scores are entered
the enclose the formula in an IF() statement:

=IF(COUNT($AA$12:$AA$28)<17,"",INDEX($A$12:$A$28, MATCH(LARGE($AB$12:$AB$28,ROW()-11),$AB$12:$AB$28,0)))

--
HTH

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


with @tiscali.co.uk


"damanwitdaplan" wrote in
message ...
Thank you so much for your help!

But now I have yet another problem that has similar results.

I need the individual results too. So right now I have.

In A12 "Quizzer #1" and the results (points) of that quizzer in AA12.
In A13 "Quizzer #2" and the results of that quizzer in AA13.
In A14 "Quizzer #3" and the results of that quizzer in AA14
In A24 "Quizzer #4" and the results of that quizzer in AA24
In A25 "Quizzer #5" and the results of that quizzer in AA25
In A26 "Quizzer #6" and the results of that quizzer in AA26
In A 27 "Quizzer #7, and the results of that quizzer in AA27
In A28 "Quizzer #8" and the results of that quizzer in AA28

Results
B42
B43
B44
B45
B46
B47
B48
B49

In C42 I have the following formula
=MAX(AA12:AB14,AA24:AB28)

In C43 I have
=LARGE((AA12:AB14,AA24:AB28),2)

In C44 I have
=LARGE((AA12:AB14,AA24:AB28),3)

And so on and so on. But I need the quizzer's name (in text) with the
highest number of points to be displayed in B42. In other words.

Results
B C
42 Quizzer #4 145 points
43 Quizzer #2 70 points
44 Quizzer #7 55 points

And so on.

In other words, I have the C column figured out but I just need help with
the B column. Can anybody help me?

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?

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?

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?

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?

The red is just what I needed. The formula you gave me works good for B12:16.
But when I enter say '10' in B13 and then I enter '10' in B26 there is no
'red'. But then when I add another '10' in say B15 then all 3 turn red. Is
there anyway that can change so that if I put in '10' in B12:16 and then put
'10' in B26:31 that they will both turn red?

Well, it works for me. I cannot think of anything that would cause what you
are getting if all your cells are referencing the same list.

I'm just off to bed now, if you want, you can send me a copy of your sheet
and I will take a look tomorrow.

--
Regards,

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


with @tiscali.co.uk


"damanwitdaplan" wrote in message
...
The red is just what I needed. The formula you gave me works good for
B12:16.
But when I enter say '10' in B13 and then I enter '10' in B26 there is no
'red'. But then when I add another '10' in say B15 then all 3 turn red. Is
there anyway that can change so that if I put in '10' in B12:16 and then
put
'10' in B26:31 that they will both turn red?

I also need to make sure that '10', '20', '30', '-5', '-10', '-15' only
appears once in the cells B12:16, B26:31. Any combonation of numbers (i.e.
'10' in B14 and '-15' in B26) also needs to be highlighted. Thanks again for
your help!

I also have the sum of B12:B16 in B17.

"damanwitdaplan" wrote:

I also need to make sure that '10', '20', '30', '-5', '-10', '-15' only
appears once in the cells B12:16, B26:31. Any combonation of numbers (i.e.
'10' in B14 and '-15' in B26) also needs to be highlighted. Thanks again for
your help!

Just to complete the thread for the archives, the OP wanted conditional
formatting for any duplicate value in a row or any two of the values he gave
below in a row.

Two suggestions, with 2 conditional formats:

Any duplicate value:
=AND(B12<"",COUNTIF($B12:$U12,B12)1)

Any two of the values below:
=AND(B12<"",SUMPRODUCT(--(B12=$AA$1:$AA$7))=1,SUMPRODUCT(--($B12:$U12=$AA$1:$AA$7))1)

Or both conditions in one formula:
=AND(B12<"",OR(COUNTIF($B12:$U12,B12)1,AND(SUMPR ODUCT(--(B12=$AA$1:$AA$6))=1,SUMPRODUCT(--($B12:$U12=$AA$1:$AA$6))1)))

--

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


with @tiscali.co.uk


"damanwitdaplan" wrote in message
...
I also need to make sure that '10', '20', '30', '-5', '-10', '-15' only
appears once in the cells B12:16, B26:31. Any combonation of numbers (i.e.
'10' in B14 and '-15' in B26) also needs to be highlighted. Thanks again
for
your help!