MicrosoftWhat I am doing at present
I have downloaded a Bank Statement containing 1500 transactions. I inserted one additional column to the left of the statement heading "Account Head" which contains the Name of the Account Head which needs to debited or credited for each entry. The same has been maintained as a Structured Data Table. Using filter on the Particulars / Narration Column, I entered the Account Head in using Ctrl+Enter for the similar entries. On another sheet I used the combination of SORT, UNIQUE and FILTER to create a sorted list of Unique Account Heads used in the Bank Statement.
=SORT(FILTER(AccHead,AccHead<>""))
Here AccHead is a named range with the formula AccHead=UNIQUE(Table9[Account Head])
Now I am trying to convert this List of Sorted Unique Account Heads to a Structured Data Table, but I got the #SPILL! error
I am not sure why this error is showing. I understand the list is a result of Dynamic Arrays and TABLES are also Dynamically created.
But I request you to kindly elaborate the same and suggest a way around.
