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...
You can use a PivotTable. Note that the default behavior of a Pivot is to auto-group the dates to cleanup the row labels. Right-click a date and choose to ungroup to get desired appearance.