Forum Discussion
Need help with creating a formula
Still learning more complex formulas with excel, so some help would be appreciated with some steps to make this happen. I'm trying to process a large group of data to come up with a few different...
A 365 solution. The key is finding when the account name changes. The attached workbook contains your sample data. Ranges are dynamic.
=LET(
acct_change, XMATCH(UNIQUE(Name), Name, , -1) + 1,
AcctTotal, LAMBDA(n, IF(XOR(ROW(n) = acct_change), SUMIF(Name, n, InvoiceTotal), "")),
MAP(Name, AcctTotal)
)
