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

Invoice Number increment with Formula


Please see the attached. Need help to change the invoice number based on customer name changing. without VBA, Because i have to use in google sheet.



Excel Ninja
Hi ,

Doing this without VBA is risky because it is entirely dependent on the recalculation method being manual.

Excel has no foolproof formulaic method for detecting transitions , which is what you want here.

VBA has the Worksheet_Change event which recognizes when a worksheet cell has been changed.

If Google Sheets has any such equivalent formula which can detect transitions , you should use that rather than do it using Excel formulas.