how to generate Next invoice number After search table1 in excel ?

[krunal123]

how to generate Next invoice number After search table1 in excel ?

Dear Sir,
pleased Solve My Query We need formula For increase invoice number......

 

[Andrew Fergus]

In the worksheet called 'Register', store the 'Bill No' under column A as a number, not text. Instead of '001 use 1 and so on.

Then you can use the formula:
=MAX(Register!A:A)+1
in cell G6 on the worksheet named 'Invoice' to get the next bill number.

Format cell G6 as 000 to get the leading zeroes you want.

 

[krunal123]

In the worksheet called 'Register', store the 'Bill No' under column A as a number, not text. Instead of '001 use 1 and so on.

Then you can use the formula:
=MAX(Register!A:A)+1
in cell G6 on the worksheet named 'Invoice' to get the next bill number.

Format cell G6 as 000 to get the leading zeroes you want.

How to Use Below Trick :
~ >*()))><(

 

[Andrew Fergus]

How to Use Below Trick :
~ >*()))><(

That's my signature. It is meant to look like a fish about to eat a worm.