I am using the UNIQUE function and it's working for me perfectly win the spill is in a normal range. But then when I convert that column (that the spill is in), along with a lot of other rows, into a table, the UNIQUE function starts returning #SPILL!. I've done everything I can to make sure there is nothing obstructing the spill range, but it is not working.
Would love to understand why?
Bookmarks