Forum Discussion
Auto increment the Invoice number
Good day, Please assist me with a formulae to auto increment the Invoice number after looking up the previous value for the specific client. See attached file. Thanks.
How about this?
In B25
=IF(AND(ISNUMBER(B24),D25=D24),B24,INDEX($B$3:$B$20,MATCH(D25,$D$3:$D$20,0))+1)and copy it down.