MicrosoftI know this is a bit off topic, but if minor tweaks are still being made before release I was wondering if a minor tweak to FILTER might be possible. Basically the format of FILTER is (array, include, [if empty]) but in many if not most cases the include is a subset of array. The examples on the help page are a typical example:
=FILTER(A5:D20,(C5:C20=H1)*(A5:A20=H2),"")
but also using structured references:
=FILTER(DataTable,(DataTable[Product]=H1)*(DataTable[Region]=H2),"")
of using named ranges:
=FILTER(DataRange,(INDEX(DataRange,,3)=H1)*(INDEX(DataRange,,1)=H2),"")
I was thinking it would be helpful if a special call-out could be used to define columns from the source array table. For example using [3] or {3} or #3 or something to indicate the 3rd column of the source array table. so the above example could be something like:
=FILTER(DataRange,(#3=H1)*(#1=H2),"")
