I desire to get only 2 columns from the array in FILTER formula
for example if I have 5 columns in a table, I like the formula to return only 2 columns,
is it possible?
=SORT(FILTER(Table1,(Table1[Col5]>=H1)*(Table1[Col5]<=I1)),5,1)
I want to get Col1 and Col5 from Table1
I can do it separately.
=FILTER(Table1[Col1],(Table1[Col5]>=H1)*(Table1[Col5]<=I1))
=FILTER(Table1[Col5],(Table1[Col5]>=H1)*(Table1[Col5]<=I1))
then I don't know how to sort
Kindly help to correct me.
I attach a sample file for reference.
Thank you.
Bookmarks