Help with formulae/condition please

[www.ttdown.com]

Win98se
Office XP Pro

I record twice weekly scores for a bowls drive competition over 7
months of the year.

The winners are highlighted, based on a Conditional sum.....Max score
etc.Resulting in a Background color(green), in the cell with that
highest score. If more than 1 equal score then they will all be
highlighted.

What I would like to automate the number of wins for each player,
against their respective end of row on the worksheet.



TIA

 

[Andy B]

Hi

Post some plain text of what you have now, how it is laid out on the sheet,
and what result you are hoping for. It'll help us to advise the best way
forward!

Andy.

 

[www.ttdown.com]

Sorry about the "lack" of info'....heres a simulated score record for
3 particular dates.
Col. B are the Names.
Cols. C, D, and E are the date fields.
Col F is the number of accumulative Wins of each player.

We look down each COLUMN in turn to establish MAX.

Whoever has the MAX is then recorded in Col. F as 1 win, which
accumulates as each date is assessed.

Results below show B3(Mary) winning 1 (Col.E3), and B7(Gordon) winning
2 (Cols.C7 & D7)

My original post mentions background colors, but we can ignore that
for this excersize if it simplifies the formulae.?....just using max
of each COL....then enter into Col F as a win plus any wins already
gained from previous dates.

The cell background color is purely visual for printing etc.

My problem is relating results from Columns C,D.E shown in Row F.

Hope that helps ANDY.


A B C D E F

1 Name 1/1/04 5/1/04 15/1/04 num.wins
2 Bob 12 20 0 0
3 Mary 15 18 22 1
4 Doug 8 9 15 0
5 Alf 20 12 10 0
6 Anne 11 6 9 0
7 Gordon 25 22 12 2
8 Jim 9 0 21 0

 

[Frank Kabel]

Hi
try the following:
1. Insert as last row a maximum claculation. in your case enter in B9
the following:
=MAX(B2:B8)
and copy this for all date columns (I assume you have more than three
in your original data

2. Insert the following formula in F2
=SUMPRODUCT(--(B22=$B$9:$D$9))
and copy down for all rows

If you have more columns just adapt this formula

 

[www.ttdown.com]

Thank you Frank K......works a treat.
First time of using "Sumproduct"....I could not have done it with this
help.

ttd