Results 1 to 3 of 3

Thread: Formula for Creating code from data in cells

  1. #1

    Exclamation Formula for Creating code from data in cells



    Register for a FREE account, and/
    or Log in to avoid these ads!

    hi all i want to creat formula as defined below-
    -------------------------------------------------------------------------
    formula needed for creating Student ID


    Student ID looks like-
    CC1/ACTI/12/13/000001


    defination-


    *Code *legend (Example of data in Cell) Range of data
    --------------------------------------------------------------------------
    CC1 - Course code - (basic computer Course) Around 50 Courses
    ACTI- Center Code - (Alma Computer Training Institute) Around 10 Centers
    12 - month code - (December) 12 Month
    13 - Year Code - (2013) 2013-2099
    000001 - Sr. No. - (1) numerical value 1-999999
    ------------------------------------------------------------------------




    i have course codes as CC1 for Basic Computer Course , for all 50 Courses.
    i have Centers Codes as ACTI for Alma Computer tra..., for all centers
    month,year and sr. no. (serial number range given above)


    i want that Excel should extract code from data in the cells.


    Example-
    ----------------------------------------------------------------------------
    Sr. Center name Course Date of Enrol. Code
    ----------------------------------------------------------------------------
    1 ACTI Suraj BAsic Computer Course 31/12/13 CC1/ACTI/12/13/000001
    -----------------------------------------------------------------------------
    i want excel to generate the last cell "code" by Excel.


    i understand that i will need to create libraries for courses and Centers to convert
    into Course Code and center codes.


    what should do? design something via visual basic?
    i do not know how to use visual basic and not much knowldge of formulas in Excel


    or is it getting more complex? do i need to use some other software or some program is needed to programmed.
    microsoft Access and SQL express of any use?

    hope to get replies soon

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    If you are trying to create the code based on courses, centres, etc., you will need to create tables for each separately, showing all the courses, centres, etc and their corresponding codes. Then you can use VLOOKUP() function to lookup the proper codes and CONCATENATE them to make the final code.

    If you can post a sample workbook with some of that information, we can assist you better.


  3. #3
    Quote Originally Posted by NBVC View Post
    If you are trying to create the code based on courses, centres, etc., you will need to create tables for each separately, showing all the courses, centres, etc and their corresponding codes. Then you can use VLOOKUP() function to lookup the proper codes and CONCATENATE them to make the final code.

    If you can post a sample workbook with some of that information, we can assist you better.
    thanks a lot i will upload the worksheets tomorrow , as right now i am not in office

Posting Permissions

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