mardi 9 juillet 2019

ArrayFormula circular dependency detected

I need to make a column of helper but I'm stuck because if I'm doing it for every row it's working, but if I make it array formula its become error

for a single cell, the formula is like this

=if(AND(len(G2)>0, len(F2)>0),
    if(G2=G1, I1+1, "1"),
    if(AND(len(G2)=0, len(F2)=0), "", I1+1)
)

and i make an arrayformula like so:

={"Bundle Helper"; arrayformula(if(AND(len(G3:G)>0, len(F3:F)>0),
    if(G3:G=G2:G, I2:I+1,"1"),
    if(AND(len(G3:G)=0, len(F3:F)=0), "", I2:I+1))
)}

As I understand it, the problem is because I need a row before to add value in column "i" I1+1, but because its an array so it becomes a problem I2:I+1. is there any other way or solution for this problem?

Link to Sheet

Aucun commentaire:

Enregistrer un commentaire