Thanks to Jitin Shan, amazing 23 year old CEO from skill nation for teaching these:
After the Excel update in 2019, Excel is no longer what it used to be. A lot has changed, and an important one is excels calculation engine that allows us to input one formula and get many results – earlier it was one formula: one result. It affects not just the advanced but all users of excel.
It works best when the data range is converted to a table. When the source data is an excel table, the spilled array automatically expands as new data rows are added to the table.
Typing in a new cell, the range of the table, and pressing enter gives us a spilled array of all source cells. Click anywhere inside the range, and you see the blue border where the "spill" has occurred.
- Formula is editable only in the 1st cell.
- Blue border helps you see till what cell has the formula been spilled
- You do not copy the formatting of your data
- If you have something blocking the spill, you will get the #SPILL error.
No comments:
Post a Comment