• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

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?