How do execute a dynamic formula showing a list of invoice numbers in sequence

[liabilityquek]

Hi Bosco

with regards to my previous thread: https://chandoo.org/forum/threads/using-row-indirect-start-”-”-end.43557/#post-260142

Formula used: =IF((LEN($A2)=10)*(SUM($A2:A2)=$A2),$A2,IF(COLUMN(A1)<=-IMREAL(IMDIV($A2&"i","1+i"))*2+1,IMREAL($A2&"i")+ROW(A1)-1,""))

I tried your formula and amended column to row at the last part of the formula, did not display the invoice values I wanted. Would you be able to take a look at my attachment and what is wrong?

 

[Nebu]

Hi:

May be this using power query.

Thanks