Forum Discussion
Formula required
The last two digits of the student number indicate the year the student enrolled. In F4 create a formula that will put "20" followed by the last two digits of the Student ID, e.g. 2015. Copy the form...
I have used a recent Excel 365 function
= 2000 + TEXTAFTER(studentID,"/")It should return the entire column as a dynamic range.