LET and SCAN Just Did This #excel #formulas
By Chandoo
Community Score: 50% | 11.6K views | 2mo
0 community ratings: null thumbs up, null thumbs down
In this installment of "50 Excel Formulas in 50 Days" we explore a mind-boggling trick to calculate the maximum streak of increasing shipment values. Learn how to use excel formulas and functions and the lambda function to identify and count consecutive increases in your data. This excel tutorial will enhance your excel tricks for data analysis. #excel #chandoo
Tags: chandoo, chandoo.org, Excel, spreadsheets, microsoft excel, excel tricks, excel formulas and functions, excel tutorial, lambda function
More from Chandoo
- 20 AI Terms Explained in Plain English in 20 minutes 🕓 — Score: 50%
- Learn Advance Excel Formulas in an Hour - FREE Masterclass — Score: 50%
- 5 HR KPIs Every Analyst Needs to Master #HRAnalytics #KPIs — Score: 50%
- This simple Excel trick saves me hours on MIS reports 💡 — Score: 50%
- End to End Power Query Data Cleaning Masterclass [FREE Workbook] — Score: 50%
- Here is why I think Excel skills are still relevant in the age of AI — Score: 50%