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

Invoice Number increment with Formula

Juniad

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

Attachments

NARAYANK991

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.

Narayan
 
Top