Sep 12 2022 02:05 AM
Hello Everyone
Please, I want to categorize the names of students under a certain number from a column that already exists.. meaning I have a group of names in a column and each name has a different number in another column, let it be 270,280,273. Which I need to classify each student under each number.
Thanks a lot
Sep 12 2022 02:24 AM
Sep 13 2022 01:34 AM
Sep 13 2022 03:40 AM - edited Sep 13 2022 03:43 AM
Incase you need name of respective number, then use Vlookup or Index match formula.
I guess you need unique id for each student, in that case just create by your own idea like
Academic Year 2022 Students major subject 01 Science, 02 Mathematics, 03 Computer Science etc., Student Roll Number 270. First four digits can be academic year and next 2 digits can be subject and then roll number, finally you can put like 202201270, 202202280 etc.,