Little bit of a bizarre request however I’m making an attempt to make use of google sheets filter perform to filter information in a single tab based mostly on standards in one other.
I’ve 2 completely different dishes known as A & B which have the identical listing of elements x,y,z,…
In every dish now we have completely different merchandise A_2 & A_1. I need the filter to populate the identical listing of elements twice for A_2 & A_1. See instance spreadsheet right here: https://docs.google.com/spreadsheets/d/1IjprF0yeBLFNC7M0VXyoRWNP9rmTr1qyson_1LnCWew/edit?usp=sharing
It isn’t an choice to populate the ‘ingredient listing’ tab by product sort slightly than dish sort as now we have many dishes so this provides a number of product entries.
Possibly there is a approach with rely? e.g. if rely = 2 then return all elements twice
I hope that is sensible thanks!