You can also try using Excel’s built-in Evaluate Formula feature to review array formulas. Here’s how you can do that: First, select the problematic cell and look into its formula bar.

Advanced Excel techniques to tackle the array of arrays challenge. ... How to create a timeline charts in Excel; Solution 2: Using Choose Rows and XMatch Functions.

If you select the actual Table, Excel will use a longer version, Names[[#All],[First Name]], but the shorter reference works the same, so don’t worry about that slight difference.