How to find maximum quantity sold with item description in the given data

[tawakal]

[TABLE="width: 1075"]
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD] PRODUCT DESCRIPTION[/TD]
[TD] QUANTITY[/TD]
[TD] GROSS[/TD]
[TD] DISCOUNT[/TD]
[TD] TOTAL[/TD]
[TD]RETURN QTY[/TD]
[TD]RETURN VALUE[/TD]
[TD]NET SALES QTY[/TD]
[TD]NET SALES VALUE[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]COMPUTER MADE[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]AMBER LAWN COMPUTER (SECOND)[/TD]
[TD] 39.00[/TD]
[TD] 65,550.00[/TD]
[TD] - [/TD]
[TD] 65,550.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 39.00[/TD]
[TD] 65,550.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3 PCS (SECOND)[/TD]
[TD] 41.00[/TD]
[TD] 105,950.00[/TD]
[TD] - [/TD]
[TD] 105,950.00[/TD]
[TD] 30.00[/TD]
[TD] 75,000.00[/TD]
[TD] 11.00[/TD]
[TD] 30,950.00[/TD]
[/TR]
[TR]
[TD]AMBER LAWN COMPUTER 3PCS (FRESH)[/TD]
[TD] 1,128.00[/TD]
[TD] 2,925,694.95[/TD]
[TD] 23,688.00[/TD]
[TD] 2,902,006.95[/TD]
[TD] 40.00[/TD]
[TD] 97,110.00[/TD]
[TD] 1,088.00[/TD]
[TD] 2,804,896.95[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH H.SAMPLE[/TD]
[TD] 4.00[/TD]
[TD] 13,400.00[/TD]
[TD] - [/TD]
[TD] 13,400.00[/TD]
[TD] 8.00[/TD]
[TD] 24,600.00[/TD]
[TD] (4.00)[/TD]
[TD] (11,200.00)[/TD]
[/TR]
[TR]
[TD]CUT PCS_AMBER LAWN COMPUTER[/TD]
[TD] 41.50[/TD]
[TD] 12,450.00[/TD]
[TD] - [/TD]
[TD] 12,450.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 41.50[/TD]
[TD] 12,450.00[/TD]
[/TR]
[TR]
[TD]CUT PCS_PLAIN CAMBRIC & LAWN[/TD]
[TD] 324.25[/TD]
[TD] 21,265.00[/TD]
[TD] - [/TD]
[TD] 21,265.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 324.25[/TD]
[TD] 21,265.00[/TD]
[/TR]
[TR]
[TD]CUT PCS_PLAIN SUPREME VOIL[/TD]
[TD] 116.00[/TD]
[TD] 8,120.00[/TD]
[TD] - [/TD]
[TD] 8,120.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 116.00[/TD]
[TD] 8,120.00[/TD]
[/TR]
[TR]
[TD]CUT PCS_SUPREME VOIL COMPUTER[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 250.75[/TD]
[TD] 25,075.00[/TD]
[TD] (250.75)[/TD]
[TD] (25,075.00)[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#521[/TD]
[TD] 6.00[/TD]
[TD] 23,100.00[/TD]
[TD] - [/TD]
[TD] 23,100.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 6.00[/TD]
[TD] 23,100.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#981[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 1.00[/TD]
[TD] 3,182.00[/TD]
[TD] (1.00)[/TD]
[TD] (3,182.00)[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#798[/TD]
[TD] 1.00[/TD]
[TD] 3,300.00[/TD]
[TD] - [/TD]
[TD] 3,300.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 1.00[/TD]
[TD] 3,300.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#920[/TD]
[TD] 1.00[/TD]
[TD] 2,700.00[/TD]
[TD] - [/TD]
[TD] 2,700.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 1.00[/TD]
[TD] 2,700.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#949[/TD]
[TD] 2.00[/TD]
[TD] 6,700.00[/TD]
[TD] - [/TD]
[TD] 6,700.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 2.00[/TD]
[TD] 6,700.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#962[/TD]
[TD] 2.00[/TD]
[TD] 6,700.00[/TD]
[TD] - [/TD]
[TD] 6,700.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 2.00[/TD]
[TD] 6,700.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#972[/TD]
[TD] 2.00[/TD]
[TD] 6,700.00[/TD]
[TD] - [/TD]
[TD] 6,700.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 2.00[/TD]
[TD] 6,700.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#108[/TD]
[TD] 1.00[/TD]
[TD] 3,300.00[/TD]
[TD] - [/TD]
[TD] 3,300.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 1.00[/TD]
[TD] 3,300.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#139[/TD]
[TD] 2.00[/TD]
[TD] 6,200.00[/TD]
[TD] - [/TD]
[TD] 6,200.00[/TD]
[TD] 2.00[/TD]
[TD] 6,660.00[/TD]
[TD] - [/TD]
[TD] (460.00)[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#183[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 1.00[/TD]
[TD] 3,182.00[/TD]
[TD] (1.00)[/TD]
[TD] (3,182.00)[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#191[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 1.00[/TD]
[TD] 3,450.00[/TD]
[TD] (1.00)[/TD]
[TD] (3,450.00)[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#186[/TD]
[TD] 4.00[/TD]
[TD] 13,900.00[/TD]
[TD] - [/TD]
[TD] 13,900.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 4.00[/TD]
[TD] 13,900.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#189[/TD]
[TD] 2.00[/TD]
[TD] 6,750.00[/TD]
[TD] - [/TD]
[TD] 6,750.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 2.00[/TD]
[TD] 6,750.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#196[/TD]
[TD] 24.00[/TD]
[TD] 85,295.00[/TD]
[TD] 2,432.00[/TD]
[TD] 82,863.00[/TD]
[TD] 1.00[/TD]
[TD] 3,182.00[/TD]
[TD] 23.00[/TD]
[TD] 79,681.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#199[/TD]
[TD] 25.00[/TD]
[TD] 96,500.00[/TD]
[TD] - [/TD]
[TD] 96,500.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 25.00[/TD]
[TD] 96,500.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#232[/TD]
[TD] 10.00[/TD]
[TD] 37,500.00[/TD]
[TD] - [/TD]
[TD] 37,500.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 10.00[/TD]
[TD] 37,500.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#261[/TD]
[TD] 40.00[/TD]
[TD] 141,640.00[/TD]
[TD] 1,672.00[/TD]
[TD] 139,968.00[/TD]
[TD] 2.00[/TD]
[TD] 7,000.00[/TD]
[TD] 38.00[/TD]
[TD] 132,968.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#238[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 1.00[/TD]
[TD] 3,263.00[/TD]
[TD] (1.00)[/TD]
[TD] (3,263.00)[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#225[/TD]
[TD] 28.00[/TD]
[TD] 101,850.00[/TD]
[TD] - [/TD]
[TD] 101,850.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 28.00[/TD]
[TD] 101,850.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#244[/TD]
[TD] 5.00[/TD]
[TD] 17,250.00[/TD]
[TD] - [/TD]
[TD] 17,250.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 5.00[/TD]
[TD] 17,250.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#275[/TD]
[TD] 22.00[/TD]
[TD] 79,900.00[/TD]
[TD] - [/TD]
[TD] 79,900.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 22.00[/TD]
[TD] 79,900.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#276[/TD]
[TD] 31.00[/TD]
[TD] 112,900.00[/TD]
[TD] - [/TD]
[TD] 112,900.00[/TD]
[TD] 2.00[/TD]
[TD] 7,100.00[/TD]
[TD] 29.00[/TD]
[TD] 105,800.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#262[/TD]
[TD] 26.00[/TD]
[TD] 90,700.00[/TD]
[TD] - [/TD]
[TD] 90,700.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 26.00[/TD]
[TD] 90,700.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#202[/TD]
[TD] 19.00[/TD]
[TD] 67,870.00[/TD]
[TD] 1,672.00[/TD]
[TD] 66,198.00[/TD]
[TD] 4.00[/TD]
[TD] 14,000.00[/TD]
[TD] 15.00[/TD]
[TD] 52,198.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#215[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 6.00[/TD]
[TD] 20,106.00[/TD]
[TD] (6.00)[/TD]
[TD] (20,106.00)[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#229[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 11.00[/TD]
[TD] 35,948.00[/TD]
[TD] (11.00)[/TD]
[TD] (35,948.00)[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#208[/TD]
[TD] 1.00[/TD]
[TD] 2,700.00[/TD]
[TD] - [/TD]
[TD] 2,700.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 1.00[/TD]
[TD] 2,700.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#209[/TD]
[TD] 10.00[/TD]
[TD] 34,400.00[/TD]
[TD] - [/TD]
[TD] 34,400.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 10.00[/TD]
[TD] 34,400.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#210[/TD]
[TD] 4.00[/TD]
[TD] 13,400.00[/TD]
[TD] - [/TD]
[TD] 13,400.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 4.00[/TD]
[TD] 13,400.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#211[/TD]
[TD] 1.00[/TD]
[TD] 3,300.00[/TD]
[TD] - [/TD]
[TD] 3,300.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 1.00[/TD]
[TD] 3,300.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#213[/TD]
[TD] 4.00[/TD]
[TD] 13,400.00[/TD]
[TD] - [/TD]
[TD] 13,400.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 4.00[/TD]
[TD] 13,400.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#221[/TD]
[TD] 2.00[/TD]
[TD] 6,700.00[/TD]
[TD] - [/TD]
[TD] 6,700.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 2.00[/TD]
[TD] 6,700.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#222[/TD]
[TD] 1.00[/TD]
[TD] 3,300.00[/TD]
[TD] - [/TD]
[TD] 3,300.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 1.00[/TD]
[TD] 3,300.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#223[/TD]
[TD] 3.00[/TD]
[TD] 10,700.00[/TD]
[TD] - [/TD]
[TD] 10,700.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 3.00[/TD]
[TD] 10,700.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#219[/TD]
[TD] 40.00[/TD]
[TD] 148,000.00[/TD]
[TD] - [/TD]
[TD] 148,000.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 40.00[/TD]
[TD] 148,000.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#235[/TD]
[TD] 2.00[/TD]
[TD] 6,600.00[/TD]
[TD] - [/TD]
[TD] 6,600.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 2.00[/TD]
[TD] 6,600.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#255[/TD]
[TD] 6.00[/TD]
[TD] 21,300.00[/TD]
[TD] - [/TD]
[TD] 21,300.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 6.00[/TD]
[TD] 21,300.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#254[/TD]
[TD] 22.00[/TD]
[TD] 78,300.00[/TD]
[TD] - [/TD]
[TD] 78,300.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 22.00[/TD]
[TD] 78,300.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#242[/TD]
[TD] 8.00[/TD]
[TD] 35,800.00[/TD]
[TD] - [/TD]
[TD] 35,800.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 8.00[/TD]
[TD] 35,800.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#257[/TD]
[TD] 39.00[/TD]
[TD] 141,210.00[/TD]
[TD] 2,432.00[/TD]
[TD] 138,778.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 39.00[/TD]
[TD] 138,778.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#243[/TD]
[TD] 8.00[/TD]
[TD] 36,000.00[/TD]
[TD] - [/TD]
[TD] 36,000.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 8.00[/TD]
[TD] 36,000.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#260[/TD]
[TD] 27.00[/TD]
[TD] 101,250.00[/TD]
[TD] - [/TD]
[TD] 101,250.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 27.00[/TD]
[TD] 101,250.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#274[/TD]
[TD] 24.00[/TD]
[TD] 85,290.00[/TD]
[TD] 1,672.00[/TD]
[TD] 83,618.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 24.00[/TD]
[TD] 83,618.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#285[/TD]
[TD] 32.00[/TD]
[TD] 115,250.00[/TD]
[TD] - [/TD]
[TD] 115,250.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 32.00[/TD]
[TD] 115,250.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#283[/TD]
[TD] 12.00[/TD]
[TD] 42,550.00[/TD]
[TD] - [/TD]
[TD] 42,550.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 12.00[/TD]
[TD] 42,550.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#282[/TD]
[TD] 39.00[/TD]
[TD] 136,840.00[/TD]
[TD] 760.00[/TD]
[TD] 136,080.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 39.00[/TD]
[TD] 136,080.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#284[/TD]
[TD] 15.00[/TD]
[TD] 53,950.00[/TD]
[TD] - [/TD]
[TD] 53,950.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 15.00[/TD]
[TD] 53,950.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#281[/TD]
[TD] 80.00[/TD]
[TD] 283,620.00[/TD]
[TD] 3,344.00[/TD]
[TD] 280,276.00[/TD]
[TD] 6.00[/TD]
[TD] 21,000.00[/TD]
[TD] 74.00[/TD]
[TD] 259,276.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#289[/TD]
[TD] 80.00[/TD]
[TD] 292,370.00[/TD]
[TD] 1,672.00[/TD]
[TD] 290,698.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 80.00[/TD]
[TD] 290,698.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#290[/TD]
[TD] 23.00[/TD]
[TD] 82,200.00[/TD]
[TD] 1,672.00[/TD]
[TD] 80,528.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 23.00[/TD]
[TD] 80,528.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#298[/TD]
[TD] 19.00[/TD]
[TD] 67,250.00[/TD]
[TD] - [/TD]
[TD] 67,250.00[/TD]
[TD] 2.00[/TD]
[TD] 7,000.00[/TD]
[TD] 17.00[/TD]
[TD] 60,250.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#293[/TD]
[TD] 17.00[/TD]
[TD] 64,350.00[/TD]
[TD] - [/TD]
[TD] 64,350.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 17.00[/TD]
[TD] 64,350.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#291[/TD]
[TD] 18.00[/TD]
[TD] 69,500.00[/TD]
[TD] - [/TD]
[TD] 69,500.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 18.00[/TD]
[TD] 69,500.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#300[/TD]
[TD] 20.00[/TD]
[TD] 71,900.00[/TD]
[TD] - [/TD]
[TD] 71,900.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 20.00[/TD]
[TD] 71,900.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#301[/TD]
[TD] 18.00[/TD]
[TD] 62,800.00[/TD]
[TD] - [/TD]
[TD] 62,800.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 18.00[/TD]
[TD] 62,800.00[/TD]
[/TR]
[TR]
[TD]SWISS VOIL COMPUTER 3PCS FRESH D#295[/TD]
[TD] 1.00[/TD]
[TD] 3,550.00[/TD]
[TD] - [/TD]
[TD] 3,550.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 1.00[/TD]
[TD] 3,550.00[/TD]
[/TR]
[TR]
[TD]COMPUTER MADE Total[/TD]
[TD] 2,522.75[/TD]
[TD] 6,150,964.95[/TD]
[TD] 41,016.00[/TD]
[TD] 6,109,948.95[/TD]
[TD] 368.75[/TD]
[TD] 356,858.00[/TD]
[TD] 2,154.00[/TD]
[TD] 5,753,090.95[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]ZAM ZAM MADE[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]GOLDEN WHITE ALL OVER (FRESH)[/TD]
[TD] 13.50[/TD]
[TD] 3,645.00[/TD]
[TD] - [/TD]
[TD] 3,645.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 13.50[/TD]
[TD] 3,645.00[/TD]
[/TR]
[TR]
[TD]AMBER LAWN SHIFLY SHIRT (SECOND)[/TD]
[TD] 68.75[/TD]
[TD] 12,991.00[/TD]
[TD] - [/TD]
[TD] 12,991.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 68.75[/TD]
[TD] 12,991.00[/TD]
[/TR]
[TR]
[TD]AMBER LAWN SHIFLY SHILWAR (SECOND)[/TD]
[TD] 62.50[/TD]
[TD] 7,199.00[/TD]
[TD] - [/TD]
[TD] 7,199.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 62.50[/TD]
[TD] 7,199.00[/TD]
[/TR]
[TR]
[TD]AMBER LAWN SHIFLY DUPATTAH (SECOND)[/TD]
[TD] 68.75[/TD]
[TD] 12,409.98[/TD]
[TD] - [/TD]
[TD] 12,409.98[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 68.75[/TD]
[TD] 12,409.98[/TD]
[/TR]
[TR]
[TD]AMBER LAWN SHIFLY SINGLE SHIRT (FRESH)[/TD]
[TD] 361.25[/TD]
[TD] 107,343.75[/TD]
[TD] - [/TD]
[TD] 107,343.75[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 361.25[/TD]
[TD] 107,343.75[/TD]
[/TR]
[TR]
[TD]LAWN SHIFLY CHICKEN KARI (SECOND)[/TD]
[TD] 6.00[/TD]
[TD] 12,600.00[/TD]
[TD] - [/TD]
[TD] 12,600.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 6.00[/TD]
[TD] 12,600.00[/TD]
[/TR]
[TR]
[TD]AMBER LAWN SHIFLY SHIRT (FRESH)[/TD]
[TD] 1,302.25[/TD]
[TD] 391,065.50[/TD]
[TD] - [/TD]
[TD] 391,065.50[/TD]
[TD] 19.25[/TD]
[TD] 5,142.50[/TD]
[TD] 1,283.00[/TD]
[TD] 385,923.00[/TD]
[/TR]
[TR]
[TD]AMBER LAWN SHIFLY DUPATTAH (FRESH)[/TD]
[TD] 1,299.25[/TD]
[TD] 376,913.10[/TD]
[TD] - [/TD]
[TD] 376,913.10[/TD]
[TD] 19.25[/TD]
[TD] 4,869.86[/TD]
[TD] 1,280.00[/TD]
[TD] 372,043.24[/TD]
[/TR]
[TR]
[TD]AMBER LAWN SHIFLY SHILWAR (FRESH)[/TD]
[TD] 1,187.50[/TD]
[TD] 150,912.50[/TD]
[TD] - [/TD]
[TD] 150,912.50[/TD]
[TD] 17.50[/TD]
[TD] 2,012.50[/TD]
[TD] 1,170.00[/TD]
[TD] 148,900.00[/TD]
[/TR]
[TR]
[TD]PLAIN TABOKE LAWN BARAPANNA (FRESH)[/TD]
[TD] 354.00[/TD]
[TD] 31,860.00[/TD]
[TD] - [/TD]
[TD] 31,860.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 354.00[/TD]
[TD] 31,860.00[/TD]
[/TR]
[TR]
[TD]PLAIN AMBER LAWN (FRESH)[/TD]
[TD] 1,278.50[/TD]
[TD] 222,604.50[/TD]
[TD] - [/TD]
[TD] 222,604.50[/TD]
[TD] 104.50[/TD]
[TD] 13,062.50[/TD]
[TD] 1,174.00[/TD]
[TD] 209,542.00[/TD]
[/TR]
[TR]
[TD]PLAIN SUPREME VOIL BARA PANNA[/TD]
[TD] 1,334.75[/TD]
[TD] 139,362.50[/TD]
[TD] - [/TD]
[TD] 139,362.50[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 1,334.75[/TD]
[TD] 139,362.50[/TD]
[/TR]
[TR]
[TD]PLAIN CAMBRIC (FRESH)[/TD]
[TD] 7,251.50[/TD]
[TD] 1,034,931.48[/TD]
[TD] - [/TD]
[TD] 1,034,931.48[/TD]
[TD] 480.00[/TD]
[TD] 68,212.50[/TD]
[TD] 6,771.50[/TD]
[TD] 966,718.98[/TD]
[/TR]
[TR]
[TD]PLAIN CAMBRIC & LAWN (SECOND)[/TD]
[TD] 290.50[/TD]
[TD] 23,240.00[/TD]
[TD] - [/TD]
[TD] 23,240.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 290.50[/TD]
[TD] 23,240.00[/TD]
[/TR]
[TR]
[TD]PRINT CAMBRIC WHITE, BLACK, BLUE[/TD]
[TD] 5,972.75[/TD]
[TD] 1,027,558.45[/TD]
[TD] - [/TD]
[TD] 1,027,558.45[/TD]
[TD] 200.00[/TD]
[TD] 34,700.00[/TD]
[TD] 5,772.75[/TD]
[TD] 992,858.45[/TD]
[/TR]
[TR]
[TD]PLAIN SUPREME VOIL_FRAME PACKING[/TD]
[TD] 112.00[/TD]
[TD] 25,759.90[/TD]
[TD] - [/TD]
[TD] 25,759.90[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 112.00[/TD]
[TD] 25,759.90[/TD]
[/TR]
[TR]
[TD]AMBER LAWN SHIFLI CHICKEN KARI (FRESH)[/TD]
[TD] 86.00[/TD]
[TD] 227,300.00[/TD]
[TD] - [/TD]
[TD] 227,300.00[/TD]
[TD] 37.00[/TD]
[TD] 92,700.00[/TD]
[TD] 49.00[/TD]
[TD] 134,600.00[/TD]
[/TR]
[TR]
[TD]PRINT CAMBRIC WHITE, BLACK, BLUE (SECOND)[/TD]
[TD] 439.00[/TD]
[TD] 52,680.00[/TD]
[TD] - [/TD]
[TD] 52,680.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 439.00[/TD]
[TD] 52,680.00[/TD]
[/TR]
[TR]
[TD]GOLDEN WHITE BORDER (FRESH)[/TD]
[TD] 38.75[/TD]
[TD] 9,737.50[/TD]
[TD] - [/TD]
[TD] 9,737.50[/TD]
[TD] 38.50[/TD]
[TD] 10,982.50[/TD]
[TD] 0.25[/TD]
[TD] (1,245.00)[/TD]
[/TR]
[TR]
[TD]LAWN SHIFLY EMB SINGLE DUPATTAH (FRESH)[/TD]
[TD] 36.00[/TD]
[TD] 4,339.90[/TD]
[TD] - [/TD]
[TD] 4,339.90[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 36.00[/TD]
[TD] 4,339.90[/TD]
[/TR]
[TR]
[TD]PRINT CAMBRIC WHITE, ( CUT PIECE)[/TD]
[TD] 4.75[/TD]
[TD] 332.50[/TD]
[TD] - [/TD]
[TD] 332.50[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 4.75[/TD]
[TD] 332.50[/TD]
[/TR]
[TR]
[TD]LAWN SHIFFLI CHICKEN KARI SINGLE SHIRT ( FRESH )[/TD]
[TD] 14.00[/TD]
[TD] 17,150.00[/TD]
[TD] - [/TD]
[TD] 17,150.00[/TD]
[TD] 27.00[/TD]
[TD] 27,648.00[/TD]
[TD] (13.00)[/TD]
[TD] (10,498.00)[/TD]
[/TR]
[TR]
[TD]LAWN SHIFFLI CHICKEN KARI SINGLE SHIRT ( SECOND )[/TD]
[TD] 82.00[/TD]
[TD] 82,195.00[/TD]
[TD] - [/TD]
[TD] 82,195.00[/TD]
[TD] 10.00[/TD]
[TD] 10,000.00[/TD]
[TD] 72.00[/TD]
[TD] 72,195.00[/TD]
[/TR]
[TR]
[TD]PRINT SWISS VOILE ( FRAME PACKING ) SECOND[/TD]
[TD] 20.00[/TD]
[TD] 2,400.00[/TD]
[TD] - [/TD]
[TD] 2,400.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 20.00[/TD]
[TD] 2,400.00[/TD]
[/TR]
[TR]
[TD]LAWN SHIFFLI CHICKEN KARI ( STITCHED PES )[/TD]
[TD] 117.00[/TD]
[TD] 193,050.00[/TD]
[TD] - [/TD]
[TD] 193,050.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] 117.00[/TD]
[TD] 193,050.00[/TD]
[/TR]
[TR]
[TD]ZAM ZAM MADE Total[/TD]
[TD] 21,801.25[/TD]
[TD] 4,169,581.56[/TD]
[TD] - [/TD]
[TD] 4,169,581.56[/TD]
[TD] 953.00[/TD]
[TD] 269,330.36[/TD]
[TD] 20,848.25[/TD]
[TD] 3,900,251.20[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] GRAND TOTAL [/TD]
[TD] 24,324.00[/TD]
[TD] 10,320,546.51[/TD]
[TD] 41,016.00[/TD]
[TD] 10,279,530.51[/TD]
[TD] 1,321.75[/TD]
[TD] 626,188.36[/TD]
[TD] 23,002.25[/TD]
[TD] 9,653,342.15[/TD]
[/TR]
</tbody>[/TABLE]

 

[igold]

Hi tawakal,

Welcome to the MrExcel Forum.

You may have to be a little more precise in your requirement. I have looked at your data and there are no duplicate (similar but not duplicate) Product Descriptions. Therefore the maximum sold is the quantity listed.

If you want to find the max sold within a group of similar Product Descriptions, please provide us the criteria we should use to group the similar descriptions.

 

[Toadstool]

tawakal,

As igold said it would help if you provided more guidance but let me make some major assumptions and see how close I am...

Option 1
The simplest way would be to select the given data then use Data, Sort to sort highest to lowest. You may see some Totals and Grand Totals but then you'd see your highest selling Product Description.

Option 2
Let me try another assumption with a formula solution: You want to see the highest selling for a product category (COMPUTER MADE or ZAM ZAM MADE. COMPUTER MADE category quantities run from cell B4 down to B67 so I could find an unused cell and enter into it
=MAX(B4:B67) to get the maximum quantity of 1128.
Now I find another unused cell and enter
=INDEX(A4:A67,MATCH(MAX(B4:B67),B4:B67,0)) to get the description of that maximum 1128 sale.
If you want to do the same for ZAM ZAM MADE then you'd use the cell range A72:A96 and B72:B96

Option 3
Now let me make a huge assumption. This appears to be from a computer generated report, so the number of rows for a category will change as products are added/removed and you may even add a category if you start selling another range (e.g. OMKAR MADE). I assume you want to just take your latest computer generated report and paste it into an Excel worksheet (let me call it "MyData" for example) and have Excel answer your question.
I will further assume that you want the maximum quantity sold for each category, that if two products in the same category have the same quantity sold then you're OK with just seeing the first found.

Here is my suggested solution and I know I could have combined some columns into the formulae but I wanted to make it easier to see what's happening. I'm not repeating your data as I'm just assuming it's in a sheet called MyData and starts at cell A1

I'm also using an Excel table so if you add another Product Category it automatically copies down the formulae.

	A	B	C	D	E	F	G	H	I	J	K	L
Product Category	Description Starts	Description Ends	Range Desc	Quantity Starts	Quantity Ends	Range Qty	Max Quantity	Max Description	1. PRODUCT DESCRIPTION
COMPUTER MADE	$A$4	$A$67	MyData!$A$4:$A$67	$B$4	$B$67	MyData!$B$4:$B$67	AMBER LAWN COMPUTER 3PCS (FRESH)	MyData!
ZAM ZAM MADE	$A$72	$A$96	MyData!$A$72:$A$96	$B$72	$B$96	MyData!$B$72:$B$96	PLAIN CAMBRIC (FRESH)

<tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]1128[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]7251.5[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B2[/TH]
[TD="align: left"]=ADDRESS(MATCH(A2,MyData!A:A,0)+1,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C2[/TH]
[TD="align: left"]=ADDRESS(MATCH(A2&" Total",MyData!A:A,0)-1,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D2[/TH]
[TD="align: left"]=$L$2&B2&":"&C2[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E2[/TH]
[TD="align: left"]=SUBSTITUTE(B2,"$A","$B")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]F2[/TH]
[TD="align: left"]=SUBSTITUTE(C2,"$A","$B")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G2[/TH]
[TD="align: left"]=$L$2&E2&":"&F2[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H2[/TH]
[TD="align: left"]=MAX(INDIRECT(G2))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I2[/TH]
[TD="align: left"]=INDEX(INDIRECT(D2),MATCH(H2,INDIRECT(G2),0))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L1[/TH]
[TD="align: left"]=MyData!A1[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L2[/TH]
[TD="align: left"]=MID(FORMULATEXT(L1),2,(SEARCH("!",FORMULATEXT(L1))-1))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Let me explain:

• L1 just points to the data sheet cell A1 so that L2 can extract the sheet name (in case anybody renames it).
• B and C2 get the addresses to search by looking for this Product Category in the data and adding 1 so it gets past the heading. C2 does the same for Product Category "Total" so it find the last row and subtracts 1 to avoid searching the totals row.
• D2 wraps those start/end addresses around ":" to get the range.
• E2, F2 and G2 do the same for the Quantity column.
• H2 searches the quantity range for the product category and returns the maximum from the "QUANTITY" column.
• I2 INDEXes into the PRODUCT DESCRIPTION retrieving it when a match is found in column B with the max quantity.

So how close was I?

Regards,
Toadstool