Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

GROUPBY Function to Group Transactions with No Transaction Number. EMT 1855

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1854-1856.xlsx
Learn how to group transactions with no key or invoice number using dynamic spilled array 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:27) Teammates!
3. (00:38) Create Unique Identifier with SCAN
4. (03:06) GROUPBY Function
5. (03:28) HSTACK, SUM and ARRAYTOTEXT
6. (04:44) DROP Function to finish report.
7. (05:29) Summary
8. (05:45) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #reporting #groupby #groupbyfunction #PivotBy #pivottable #pivot

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

ExcelIsFunThu, February 29, 2024 2:10pm