pineapple

<tbody> Items Per Piece Qty Disc % Apple 10 2 4 Mango 15 3 5 Banana 12 5 2 Orange 18 4 6 Grapes 20 5 4 Pineapple 26 7 2 </tbody> Total Amt without Disc = Total Amt with Disc = how can i get both amounts in 2 different cells. Thanks Amit

Good Day Excel MVPs and Experts. Please advise. I want to automatically populate in any order the results in Table 1 based on data inputs table. I also want to have a button to click for the results in table 1 to "repopulate" again and again. Can anybody help me? Thanks in advance...

SHEET 1 <tbody> GIVEN ITEMS PACKING 10 APPLE 20 KGS ORANGE 20 KGS 5 BANANA 20 KGS 2 GRAPES 20 KGS WATERMELON 25 KGS STRAWBERRY 30 KGS 3 PINEAPPLE 40 KGS MANGO 10 KGS 1 POMEGRANATE 5 KGS </tbody> SHEET 2 - HOW I WANT IT TO BE: <tbody> GIVEN ITEMS PACKING 10 APPLE 20...

Hi, I am looking for a formula that will be able to populate a cell with the max value in a range based on a custom list. Example. CUSTOM LIST (Smallest to Largest) = ORANGE 00, APPLE 05, BANANA / HOLD, PINEAPPLE (If I have to have the list somewhere in my workbook it will be on a sheet...