find the largest value in a list and input a 1 in the corresponding row to its right

[zesh23]

hi,
i need help with a task i have to do for course work. the problem is to find a way to determine which is the best selling single of that week and print a 1 in the row associated with that CD.

[Migul V]

Hi, you can insert the following formula in cell C2

Please Login or Register  to view this content.

And drag it down to the other cells.
In E2 you can write

Please Login or Register  to view this content.

etc... hope it helps!