this formula works fine
=FILTER(Table1,ISNUMBER(Table1[Column3]))
but when I create a table with FILTER data, I get #SPILL! error
I attach a sample file.
this formula works fine
=FILTER(Table1,ISNUMBER(Table1[Column3]))
but when I create a table with FILTER data, I get #SPILL! error
I attach a sample file.
Unfortunately you cannot use spilled ranges in a table.
I thought so .
Thank you.
You're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks