Forum Discussion
Index and filter to mirror data
=INDEX(FILTER(Source_Sheet[[date]:[notes]],(Source_Sheet[currency]="usd")*(Source_Sheet[order]="buy")), , {1,2,3,4,6,7,8,16,17}) I'm using this formula to retrieve data from source sheet but it only ...
=FILTER(CHOOSECOLS(Source_Sheet[[date]:[notes]],{1,15,2,3,4,5,6,7,8,16,17}),(Source_Sheet[currency]="usd")*(Source_Sheet[order]="buy")) I modified this formula with the help of the community and I'm able to extract specific column that meet the criteria .
Now I'm wondering If I can use spill formula inside excel table?
Now I'm wondering If I can use spill formula inside excel table?
Tables are scalar-based. Adding FILTER to a table would result in a column of #SPILL! errors