Forum Discussion
Self populating data sheets
Paul_wfp Are you on MS365 with access to the FILTER function? If so, please see attached.
Riny_van_EekelenTotally superb thank you so much.
Paul_wfp Good to hear it worked!
Riny_van_EekelenRiny I have applied it to my actual data and it is superb , such a powerful tool. I have also enjoyed trying to understand the formula.
Many thanks again.
Paul
Paul_wfp You are welcome!! It works even better if you apply the FILTER function to structured tables. Then you don't have to worry about redefining the range to filter from every time. If you transform the entire data range in the STOCK sheet to a structured table (Ctrl-T), the formula would look like this:
=FILTER(FILTER(Table1,Table1[Order required]="Yes",""),{1,1,0,0,0,0,0,1,1,1,0,0})Add rows to the table and the FILTER will still work as "Table1" and the column "[Order required]" will automatically expand.
Riny_van_EekelenAgain, fabulous advice and help totally understand.
Have as nice a weekend as possible in Covid times.
Paul