Dynamic VLOOKUP research
You can replace the third argument of your VLOOKUP function with a MATCH function to create a dynamic formula to research your data
Dynamic function
Dynamic SUM in Excel
There is 2 methods to create a dynamic SUM in Excel. The first one uses the technique with a Table, the second one uses the function INDEX.
Create a weekly calendar with just one formula in Excel
How to create a weekly calendar with just one formula. The SEQUENCE formula does the job and it's not complex
How to use the MATCH function in Excel?
The MATCH function returns the position of an item in a list. This function is very useful to create DYNAMIC dashboard and formulas
How to Unstack Data using Excel?
Easily unstack data in Excel with this simple guide. Learn how to quickly rearrange your data for better analysis and visualization.