Forum Discussion
Self populating data sheets
- Feb 12, 2021
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!
- Paul_wfpFeb 12, 2021Copper Contributor
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
- Riny_van_EekelenFeb 12, 2021Platinum Contributor
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.
- Paul_wfpFeb 12, 2021Copper Contributor
Riny_van_EekelenAgain, fabulous advice and help totally understand.
Have as nice a weekend as possible in Covid times.
Paul