Hi All,
Is there a way to reverse the direction of a Filter spill function so that results go from bottom-up and not top-down? The attached shows the current format of my working file. I'd like to put the formula in row 20 and have the results start there and fill upwards.
Would appreciate any help.
Last edited by jeversf; 04-09-2022 at 12:28 PM.
these articles from microsoft might help you to understand how spilled arrays work:
https://support.microsoft.com/en-us/...1-87a7eb36e531
https://support.microsoft.com/en-us/...2-ef9cc9ad4023
https://support.microsoft.com/en-us/...6-40143ec7b55f
As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.
And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
Please try
=LET(f,FILTER(Sheet2!$E$8:$E$19,Sheet2!$F$8:$F$19=C5),r,ROWS(C6:C21),s,SEQUENCE(r,,1+ROWS(f)-r),IF(s>0,INDEX(f,s),""))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks