I'm trying to do something which I hope will be reasonably straightforward in Microsoft Excel. I'm using 2010.
I have two columns called
Username takes the format of something like,
Year Group is just a single digit figure, one of
In a third column, I would like to display the students' shared drives, which take the following format:
Username`. For example, the aforementioned students' paths will be:
Unfortunately, despite the numbers
10 at the start of the students' usernames matching up, there's a possibility, with a few students, that the number at the start of their username will be different to their Intake Year. As such, the only reliable value is the
Year Group figure in the second column.
How can I go about writing such an IF statement?
Thanks in advance,