Excel 2020: Replace Ctrl+Shift+Enter with Dynamic Arrays.
October 05, 2020 - by Bill Jelen
Before dynamic arrays, people would use these crazy Ctrl+Shift+Enter formulas.
Say that you have a friend who is superstitious about Friday the 13th. You want to illustrate how many Friday the 13ths your friend has lived through. Before Dynamic Arrays, you would have to use the formula below.
The same formula after dynamic arrays is still complicated, but less intimidating:
Another example from Mike Girvin's Ctrl+Shift+Enter book is to get a unique list.
Here is the formula. I won’t try to explain it to you.
The replacement formula with dynamic arrays is
Title Photo: Tetiana Shevereva at Unsplash.com
This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.