+ Reply to Thread
Results 1 to 3 of 3

Autonumber

  1. #1
    Registered User
    Join Date
    03-21-2013
    Location
    GREECE
    MS-Off Ver
    Excel 2010
    Posts
    37

    Autonumber

    Hi can i autonumber in the field A/A when i type something in field code (I ATTACH THE FILE). Thnx
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Autonumber

    Hi nik,

    Not entirely sure that this is what you want, but if you want a number generated in Column AA on the LIST-NCR TOTAL tab when you make an entry in Column Z, the following formula:

    Please Login or Register  to view this content.
    will do that for you. If you want the numbers to start at something other than 1, change the red 1 above to whatever number you want.

    If I've misunderstood you, let me know.
    Attached Files Attached Files
    Brendan.


    __________________________________________________________________________________________________
    Things to consider:

    1) You can thank any poster by clicking the * at the left of a helpful post.
    2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
    3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.

  3. #3
    Registered User
    Join Date
    03-21-2013
    Location
    GREECE
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: Autonumber

    I want it for cell A and cell B but is ok . Thnx

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1