I have spent the past day looking for the correct arrayformula for a formula which works when copying it in the cell, but I would like to have an arrayformula instead. this is my formula I copy in each cell where I want the find the value: =IFERROR(INDEX(SORTN(FILTER(Cart!A$2:C, Cart!B$2:B > C3, C…

After a while @Clement_YEROCHEWSKI I think this would be very hard to achieve with an ARRAYFORMULA setup, so I would recommend you to setup a script that triggers the copy down. I have written about it in the post Nathanael linked. If you need help about that feel free to message me.

Please give access to ariesarsenal@gmail.com . I will have a look.

Hello there @Clement_YEROCHEWSKI To be confirmed by spreadsheets buffs in this forum, but filter() already uses arrays by construction. I believe you will therefore have trouble combining filter() and arrayformula() to extend your formula across an array (in your case down a column).

hey there, I have given you access, really appreciate.

Hey there, I have been scratching my head on how to achieve it differently, but how can I return a range using anything else than filter(), I started playing around with lookup() but nah, nothing came out. thanks for helping.

If you want to take an entirely different route: Have you considered setting up an Apps Script to achieve the same result as an arrayformula() being pulled down a column? With the script, when a new row is created, your script would copy the arrayformula() from the row above. You wouldn’t need to …

Yeah Clement can apply that script to just copy it down if his formula is already correct, but I’m trying to use an Arrayformula if it works. Thanks for the shout out!

Hi Clement, I don’t know if I’m following this correctly. Are you trying to match the cart content with the owner based on the timestamp? Can you tell me a bit more on what you’re trying to do? i.e. what the formula is trying to achieve Maybe there’s an alternative.

Hi, I am trying to find the cart which matches has the same email has my product AND which has a timestamp later than my product date, as we might find multiple carts, I need to sort result by cart.date and take the closest one to product date.

@ThinhDinh and @nathanaelb , thanks a lot guys, I am now using my formula within the script you have shared, it works like a charm and this is exactly what I needed, I mean the result is what I needed, so I am really happy, I might play around with script now :slight_smile: love that feature! thanks…

Looking for an ARRAYFORMULA

Ask for Help

nathanaelb June 4, 2020, 9:17am 7

Here is a post written by @ThinhDinh

Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts

Topic		Replies	Views
Time of last post/row by user Ask for Help	11	682	October 21, 2019
Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help	125	14820	September 9, 2022
Multiple criteria sumif array formula with logic Ask for Help	23	4255	May 27, 2020
Arrayformula and filter view Ask for Help	2	571	May 14, 2022
Help with formula pls Ask for Help	9	882	June 3, 2020

Looking for an ARRAYFORMULA

Related topics