• 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

    Hui...

  • 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?
 

Attachments

  • invoice listing.xlsx
    168.7 KB · Views: 5
Hi:

May be this using power query.

Thanks
 

Attachments

  • invoice listing.xlsx
    291.2 KB · Views: 8
Back
Top