Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: help in a formula

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Lina Achkar Infantino
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I need a help in this please:

    What I am trying to do is:
    I have a purchase order starts with No. 1
    I would like that everytime I make another order the number should be added by 1.
    like as A1 = 1
    next order A1 should be equal to 2 and so on...
    and It's always the same .xlt file.
    Thanks for you help.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Lina
    How do you create another order?
    That is when the value would be incremented.
    Correct?
    Need a few more details.
    Thanks,
    Tom

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Posts
    765
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Create a file for example called ordnos.xls

    in A1 enter the starting No. ie 1 and save the file

    in your .XLT template,in the order No cell

    enter the formula =max(pathfilenameA1:a999)+1

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •