+ Reply to Thread
Results 1 to 2 of 2

Easy for some, not for me

  1. #1
    Registered User
    Join Date
    05-10-2005
    Posts
    1

    Easy for some, not for me

    I apologize in advance to all for these simple questions. I have read through several hundred pages of help but have still not found my answer. Here is the scenario:

    I want to create a worksheet that upon opening, prompts the user for input for 2 things, a PN and date. Then I want the 3rd column to create an alpha numeric code based upon the users input PLUS the pre-existing a/n code in the row above (ie: V051005001 for the 1st event today and V051005002 for the 2nd eventtoday BUT V051105001 for the 1st event for tommorow).

    I am NOT an excel expert by any means, but was recommended here by several voyuers.

    Please forgive the ignorance.

  2. #2
    Registered User
    Join Date
    05-28-2004
    Posts
    21
    Hello

    I would try the following:
    1. In cell C2 enter the following formula,
    =IF(ISNUMBER(B2),"V"&TEXT(B2,"mm")&TEXT(B2,"dd")&TEXT(B2,"yy")&TEXT(D2,"000"),"")
    2. Copy this formula down to the last cell of your input sheet that will be used.
    3. In cell D2 enter the following formula
    =IF(B2=B1,D1+1,0)
    4. Copy this formula down to the last cell of your input sheet that will be used.

    If I am understanding your request correctly this should work. Hope this helps.

+ 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