I make the bills randomly as and when I get information.
Please see the attached file
You can see the bill numbers mentioned randomly.
I am having many more parties but shown only few here, I would like to create a formula in which Cell F2 would display the next bill number
For Eg. in the Cell F2 it shows next bill number as 350
When I create a new bill in S. No. 1 as 350, the Cell F2 should automatically change to 351 as next bill number.
BUT when F2 shows 350 and I enter 353 or any other number besides 350 it should give an error.