Hi Gary,

Here is another trick to eliminate duplicate totals:

Put E,F,G helper columns in sheet1 as follows:

On Worksheet 1

Column A B C D E F G
SOLD Week1 Week2 Total Sold
Oranges 2 3 5 =D2+RAND() =A2 =D2
Pears 0 1 1 =D3+RAND() =A3 =D3
Apples 5 5 10 =D4+RAND() =A4 =D4


Put C helper column in sheet2 as follows:

On Worksheet 2

column A
Highest Sold
=VLOOKUP(C2;Sheet1!D$2:E$4;2;FALSE)
=VLOOKUP(C3;Sheet1!D$2:E$4;2;FALSE)
=VLOOKUP(C4;Sheet1!D$2:E$4;2;FALSE)

column B
=VLOOKUP(C2;Sheet1!E$2:G$4;3;FALSE)
=VLOOKUP(C3;Sheet1!E$2:G$4;3;FALSE)
=VLOOKUP(C4;Sheet1!E$2:G$4;3;FALSE)

column C
=LARGE(Sheet1!E$2:E$4;CELL("row";A2)-2)
=LARGE(Sheet1!E$2:E$4;CELL("row";A3)-2)
=LARGE(Sheet1!E$2:E$4;CELL("row";A4)-2)

Format sheet1!column E and sheet2!column C as numbers, 9 decimals!

Regards,
Stefi