Sorting levels in Excel - eg 2a 2b 2c
Hi, we use Excel for pupil level tracking. Levels are stored as 2a, 2b, 3c for example (according to QCA/SATs levelling).
I'd like to be able to sort these sensibly, but in Excel, 2a will come before 2b and so on. When we want to sort ascending, this won't work as 2a will be before 2b, but it should be the other way round.
Has anyone got any ideas for doing this?
Also- if you wanted to produce graphs of pupil progress, this will obviously make it difficult- drawing a graph using letters and numbers won't really work.
Thank you :)