Forum Discussion
Help require with excel formulas
I have a spreadsheet I have downloaded. It is a report showing the individual card payments taken over a period of a year. It has 17000 rows and 2 columns First column has dates Second com...
An alternative to a pivot is to use a formula like this:
=LET(
uDate, UNIQUE(date),
totals, SUMIF(date, uDate, payment),
HSTACK(uDate, totals)
)