Hello, how can i Create a top scorers list, from a from a schedule.

EX: FCP 0 - 2 Milan Rui Costa, Kaka

From a schedule like this how can i create a top scorers list.

Bye

Put the scorers in separate columns, say D, E, F, etc.

Some spare place, say T1:T20 list the main possible scorers.

U1: =SUMPRODUCT(--($D$1:$D$200=T1))

and copy down.

or look at a pivot table.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Relax" wrote in message
...
Hello, how can i Create a top scorers list, from a from a schedule.

EX: FCP 0 - 2 Milan Rui Costa, Kaka

From a schedule like this how can i create a top scorers list.

Bye