Forum Discussion
Ralph Kroll
May 28, 2019Copper Contributor
Can you invoke fill series sequencing logic for mixed alphanumeric data within a function?
I have customer transaction item data in a file and am trying to add an alphanumeric invoice number field to each line item (like: 2019-FI-001) before importing them into an accounting application. ...
Twifoo
May 29, 2019Silver Contributor
Assuming this example:
Customer Invoice
1 2019-FI-001
2 2019-FI-002
2 2019-FI-002
The formula in B3 is:
=IF(A3=A2,B2,
LEFT(B2,8)&
TEXT(RIGHT(B2,3)+1,"000"))
Customer Invoice
1 2019-FI-001
2 2019-FI-002
2 2019-FI-002
The formula in B3 is:
=IF(A3=A2,B2,
LEFT(B2,8)&
TEXT(RIGHT(B2,3)+1,"000"))