|
I know I can sort it but this is only one stage in a very large project as afterwards I have to add the timings and rooms and extra times and therefore I want to try and cut down the number of manual steps I have to do to get it to work. Also if someone then wants to use the sheet and wants the data in a particular order and resorts it then all the A1,2,3 will be messed up. Is there no way of doing this automatically. I thought it could possibly be done using a macro. The method I have tried is to use vlookup and rank and put the data into a separate sheet ordering them in by no of people taking exam and then putting the A1,2,3,P1,2,3 as you have done and then using a lookup to put them back in. I have had a number of problems with this mainly that there will be thousands of entries and so the sheet has to do 4/5fold that many calculations to work out the order an put the value back into the original sheet. I therefore hoped there could be an easier way to do it using just the one sheet. Sorry to be a nuisance. Many thanks
Jack
|