User Profile

akolah1966

Copper Contributor

Joined 6 years ago

3 Posts

View All Badges

User Widgets

Recent Discussions

Re: Spill Error in Excel when using Table format.
mathetes Hi Mathetes, thank you very much for your response and for the example attached. That helps a lot to understand how eveything works. Best Regards. Aspi.
Jun 14, 2020 Place Excel
34KViews
0likes
0Comments
Re: Spill Error in Excel when using Table format.
PeterBartholomew1 Hi Peter, thank you for your response. I now understand that I will need to have a blank column after my Table and then use the dynamic validation to get the unspilled results. Regards Aspi
Jun 14, 2020 Place Excel
35KViews
0likes
0Comments
Spill Error in Excel when using Table format.
Hi, I keep getting the #Spill Error when using the dynamic Xlookup function.This only happens when I use the Table format i.e.does not happen when I change the Table to a Range. I tried looking it up onGoogle but it clearly says "Spilled array formulas aren't supported in https://support.office.com/en-us/article/overview-of-excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c. Try moving your formula out of the table, or converting the table to a range (click Table Design > Tools > Convert to range)" Is there any work around to not get a Spill Error using the Table format ?? Thanks and Regards. Aspi.
Jun 14, 2020 Place Excel
Formulas and Functions
36KViews
0likes
17Comments

Recent Blog Articles

No content to show