Forum Discussion
Filter function
I have programmed a formula using the Filter function to bring a short list of items from a large spread sheet and I managed to make it work. But I need to somehow limit the list to a set of rows i...
If you do not have access to TAKE, you could always try a second filter applied to the sorted dataset
= LET(
selected, SORT(FILTER(Table1,Table1[crit]=crit),6,-1),
k, SEQUENCE(ROWS(selected)),
FILTER(selected,k<=5)
)
This formula also help me to achieve the goal. thank you so much for your time and help. have a wonderful day.