MicrosoftIn answer to you Henn Sarv ,
a) I see that You prefere #2 as placement of index-column, but what might be horizontal analog?
As far as know FILTER can only filter rows from column(s) of data and hence there is no horizontal analog.
b) what you mean in that case - #3 - column number 3 of WHAT? - any reference must be selfdescribing never depend of function or other parameters
As I said, in reference to the ARRAY that is the 1st element of the FILTER function. and as for 1, 2, 3 ... that is no different than INDEX. Basically replace the INDEX(array,, x) with #x or if you prefer it could be [x] but I was concerned that might get confused with an actual table structure reference because even though a FILTER() function typically can't be inside a TABLE it is possible. As for the 'any reference must be self describing never depend of function or other parameters' excel has already many exceptions to this. In this example alone you have INDEX( array, , 3) in which the blank parameter means all rows but that is invalid if you select multiple columns like INDEX( array, , {1,3} ) in which case it will return the 1 and 3 column entries of the 1st row. But I actually wish they fixed that to be all rows in that case also.
