+ Reply to Thread
Results 1 to 4 of 4

How to create your own ID no. and automatically in or.

  1. #1
    Forum Contributor
    Join Date
    08-20-2015
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    260

    How to create your own ID no. and automatically in or.

    Hello excel forum can i ask about this. how to create my own ID no. like this

    i want ID no. is
    AAA0001 in A1

    so when i input a data in B1
    the A1 will put a AAA0001

    and when i input in B2
    A2 will give AAA0002

    I wish you can help me this proble. thank you so much. GODBLESS.
    Last edited by jasond1992; 10-04-2016 at 05:51 AM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    Re: How to create your own ID no. and automatically in or.

    Put this formula in cell A1:

    =IF(B1="","","AAA"&TEXT(ROWS($1:1),"0000"))

    then copy down.

    Hope this helps.

    Pete

  3. #3
    Forum Contributor
    Join Date
    08-20-2015
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    260

    Re: How to create your own ID no. and automatically in or.

    Quote Originally Posted by Pete_UK View Post
    Put this formula in cell A1:

    =IF(B1="","","AAA"&TEXT(ROWS($1:1),"0000"))

    then copy down.

    Hope this helps.

    Pete
    Thank you so much sir @pete_UK this is what i want. GODBLESS sir pete thank you so much again.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    Re: How to create your own ID no. and automatically in or.

    You're welcome - glad to help.

    If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

    Also, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatically Create Graphs
    By rabidchild in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 04-30-2015, 03:55 PM
  2. Automatically create a group
    By ricardov in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-14-2012, 06:39 AM
  3. automatically create summary
    By simatao in forum Excel General
    Replies: 2
    Last Post: 11-10-2011, 01:01 PM
  4. Automatically create checkboxes?
    By devon1215 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2011, 01:01 PM
  5. Automatically create top ten lists
    By grey_fox33 in forum Excel General
    Replies: 1
    Last Post: 08-17-2011, 12:30 AM
  6. How to automatically create tables
    By h w in forum Excel General
    Replies: 5
    Last Post: 11-11-2010, 08:09 AM
  7. Create a table automatically
    By douglascaixeta in forum Excel General
    Replies: 6
    Last Post: 11-03-2008, 10:25 AM
  8. Automatically create hyperlinks
    By aposatsk in forum Excel General
    Replies: 1
    Last Post: 07-24-2006, 04:20 PM

Tags for this Thread

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