excelisfun | Worksheet Formulas to Group Transactions with No Transaction Number. Magic Trick 1854 @excelisfun | Uploaded 6 months ago | Updated 16 hours ago
Download Excel File: https://excelisfun.net/files/EMT1854-1856.xlsx
Learn how to group transactions with no key or invoice number using worksheet formulas. Group By when there is no key column and there are duplicates and empty cells. How to group transactions with no transaction number and repeating dates and empty cells.
Topics:
1. (00:00) Introduction
2. (00:31) Key Column
3. (01:35) SEQUENCE function 1 to 5
4. (01:43) FILTER function to get dates
5. (01:59) FILTER and TEXTJOIN functions to get descriptions
6. (02:40) SUMIFS to add amounts based on key column
7. (03:03) Summary
8. (03:11) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp, #datatransformation