I can have a set of independent products with independent quantities.
In Column D, I need to apply Formula-1 ONLY for the FIRST maximum quantity in Column B, for EACH product set in Column A, and Formula 2 to any other quantities within each product.
Thank you for help.
In Column D, I need to apply Formula-1 ONLY for the FIRST maximum quantity in Column B, for EACH product set in Column A, and Formula 2 to any other quantities within each product.
Thank you for help.