The introduction of LET function is fantastic.
To use the LET function in Excel, you define pairs of names and associated values, and a calculation that uses them all. You must define at least one name/value pair (a variable), and LET supports up to 126.
Look at this problem statement:
We need to know how many customers will get an incentive, based on meeting all following conditions:
a. Either of the Product Goals has to be met
b. Achievement has to be more than 100%
c. Should have been with company for > 2 years
The formula will extract numbers from text.
Another option will be to use VBA Code
Excel is fantastic. But you are really missing out if you do not use Power Query and Power Pivot.
Power Query is inbuilt in Excel under Data > Get and Transform Data.
It is an ETL tool that can connect to hundred of data sources, has 300+ transformations and…
Let us start with some numbers:
Pivot Tables are fantastic — and are such an integral part of our spreadsheet workflow that we do not even think about how powerful it is.
GETPIVOTDATA() allows you us to access values from the Pivot Table. But you still cannot modify the Pivot Table.
It would be great if…
Dynamic arrays work slightly differently in Excel and Google Sheets.
Excel takes care of it automatically.
Google Sheets requires =ARRAYFORMULA