So doing a FILTER formula that generates the descending cells until it gets to the last return is a Spill range?A Spill range is where you put a formula in one cell & it "spills" into neighboring cells.
Whilst it works in a normal cell, it cannot work inside a table & so you get a #SPILL error.
This isn't the whole sheet but the main data that I'm working with. I'm trying to build the foundation for the "Woburn" sheet. I want to build the same style sheet as "Production Capacity" sheet, but only pulling "Current Status" that contains "Woburn". I then have to go back into the "Production Capacity" and exclude anything with "Woburn" in it. I feel like any formula I'm going to want to use are going to be SPILL ranges.Can you supply a sample workbook.
I'm trying to pull in all statuses but ignore Woburn. The formula I used was =FILTER(Table_owssvr[JO'#],(Table_owssvr[Current Status]="INV To Be Kit")+(Table_owssvr[Current Status]="Kitting In Process")+(Table_owssvr[Current Status]="Production Ready")etc...,"None") I was just wondering if there was a quicker/shorter way of getting the same result by just ignoring Woburn instead of typing out every status except for Woburn.If you just want to filter the TWV_20 table, why not just use
=FILTER(TWV_20,TWV_20[STATUS]="Woburn Kitting In Process")
Although you will need to get rid of the #N/A errors in that table.