Hi Bosco,To create an array of numbers, you can use a array formula based on the ROW and INDIRECT functions.
The maximum number of the row formula can create is 1,048,576 (Excel max rows number)
Your number 4119000501 appeared exceeding the max rows number, the workaround array formula can be done by :
and will return ( in pressing F9 ) :
To create a invoice number listHi Bosco,
Appreciate your reply. Actually I am looking for a dynamic formula. My invoice no contains 10 characters; 4119000500. I have a list of invoices number whereby a cell could have a single invoice number and also a range of invoice numbers like “4119000200 - 4119000200”; which contains 24 characters.
I want to use a formula where if(len(A1) =10,A1,if len(A1) > 10, provide the list of invoice numbers <I don’t know what would be the suitable formula for this application>
Hi Bosco, 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?
New question, new post.Hi Bosco, 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?