CaitlynEXCELCopper ContributorJul 30, 2022How to subtract from the same user I know I can just do something like =E4-B6 but is there a way for it to look up by the User ID and subtract the quantities with matching Users? Show More
Patrick2788Silver ContributorJul 31, 2022CaitlynEXCEL My 365 take:=E4:E14-XLOOKUP(TEXTBEFORE(D4:D14," ")&"*",A4:A14,B4:B14,,2)
