List rows results accesing 1 by 1 incremental

(Augusto Vera) #1

I am executing a List Rows from a sheet, then I want to compare one column value to another sheet searching of non-duplicates, which if found will get added to a third sheet.

The problem is ¿how do I acces 1 by 1 incrementally the list rows results if I cannot pass it an attribute as index?, it just does not allow such thing.

I have figured that if I can store in a separate cell the index value then I could use it to acces the List Rows result 1 by 1 incrementally but stil it seems that you can only access them with fixed numbers as indexed parameters?
Captura

Any hints?

(Daniel Beckett) #2

Unfortunately nested variables aren’t supported which is really what you’re looking to use there. The best option is to use the code service and do it in JavaScript if you know how to code. Unfortunately, I’m pretty limited in what advice I can offer for code. You may want to try other communities like Stack Overflow to see if anybody can help you put together the JavaScript request