Dear Freinds,
Attached a sample file and request your help in matching data as per required format with any formula.
Thanks
Available Data
Purchase Invoice No Part Number Purchase Qty Sales Invoice Sales Qty
980317752 0003300003J 32 GeaOak-BG-1213-02326 15
980318458 0003300003J 45 GeaOak-MY-1213-01157 50
980318901 0003300003J 5 GeaOak-HI-1213-02239 50
Required Format
Purchase Invoice No Part Number Purchase Qty Sales Invoice Sales Qty
980317752 0003300003J 15 GeaOak-BG-1213-02326 15
980317752 0003300003J 17 GeaOak-MY-1213-01157 17
980318458 0003300003J 37 GeaOak-MY-1213-01157 37
980318458 0003300003J 8 GeaOak-HI-1213-02239 50
980318901 0003300003J 5 GeaOak-HI-1213-02239 42
GeaOak-HI-1213-02239 37
Bookmarks