Completed
15. How to create multiple columns with different calculations with GROUPBY, LET, DROP and TAKE Functions.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
GROUPBY Excel Function: Creating Single Cell Reports - 11 Examples
Automatically move to the next video in the Classroom when playback concludes
- 1 1. Introduction to GROUPBY, PIVOTBY and the new Lambda Replacement Functions
- 2 2. Compare arguments in GROUPBY and PIVOTBY functions.
- 3 3. GROUPBY and the 7 arguments.
- 4 4. 16 New Lambda Replacement Functions.
- 5 5. New Lambda Replacement Functions as replacement for LAMBDA.
- 6 6. PERCENTAGE of in GROUPBY Function.
- 7 7. Why use formulas rather than PivotTables.
- 8 8. Two Fields in Row Area of Report.
- 9 9. Problem: No Label for Calculation Column. Look at field_header argument.
- 10 10. Two Columns of calculations in report.
- 11 11. Add Custom Header Labels to Report with VSTCK Function and Array Constant.
- 12 12. Subtotals
- 13 13. Conditional Formatting for dynamic Report.
- 14 14. F5 Go To Trick to find Conditional Formatting in Report.
- 15 15. How to create multiple columns with different calculations with GROUPBY, LET, DROP and TAKE Functions.
- 16 16. Filter GROUPBY Report with Contains Criteria.
- 17 17. Filter GROUPBY Report with Criteria from a list.
- 18 18. Using LAMBDA in the GROUPBY Function: two examples.
- 19 19. Creating Array Calculation in values argument of GROUPBY Function.
- 20 20. Create Fully Dynamic GROUPBY Report with Formulas Inputs from Worksheet Cells.
- 21 21. Summary
- 22 22. Closing, Video Links
