Forum Discussion
Excel
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...
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.,