Formula for Creating code from data in cells

abhiflexy

New member
Joined
Jan 2, 2014
Messages
2
Reaction score
0
Points
0
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?

:pray2: hope to get replies soon
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
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.
 

abhiflexy

New member
Joined
Jan 2, 2014
Messages
2
Reaction score
0
Points
0
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
 
Top