LinkBack URL
About LinkBacks
I'm trying to use the UNIQUE function to generate my list of unique vales.
=UNIQUE(Query1[Work Order],FALSE,FALSE)
=UNIQUE(QueryVisual!U2:U1110,FALSE,FALSE)
Both of these return #SPILL! errors. Clearly I am not understanding the spill error.
I'm trying to use the UNIQUE function to generate my list of unique vales.
=UNIQUE(Query1[Work Order],FALSE,FALSE)
=UNIQUE(QueryVisual!U2:U1110,FALSE,FALSE)
Both of these return #SPILL! errors. Clearly I am not understanding the spill error.
Last edited by Lacaycer; 12-22-2020 at 09:37 AM. Reason: #SPILL! and tables dont go together.
Are you putting the formula into a structured table?
I was, I think I've given up on that.
I entered the same original formula in outside of the table and it worked without the #SPILL error.
It would be nice if I could use UNIQUE within a table just to clean up all future refencing
Unfortunately Spilled arrays are not allowed in Tables, which is why you got the error.
Please try
=INDEX(UNIQUE(Query1[Work Order]),ROW(Table1[@])-ROW(Table1[#Headers]))
THere is an error message related to the Table1 ref.
It's fine now. I just cant use it in a table.
I'll mark this as solved now
There are instructions at the top of the page explaining how to attach your sample workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks