Auto Generate Numbers

B

Biff

Hi Dane,

Here's a couple of ways:

If you already have your application in use and the order#
is in column C, you could use a formula like either of
these:

=C1+1 Simply add 1 to the next entry

OR

=MAX(C:C)+1 Basiclly does the same thing

Then just copy down as needed. You can suppress the
display if the other pertinent info for that transaction
has not been entered by doing something like this:

=IF(ISBLANK(A1),"",C1+1))

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top