Hi All,
Long time reader first time poster here!
I have an excel 2007 spreadsheet that holds students grades as a percentage.
What I'd like to do initially is display them on a scale from 0-100 with the student name next to each mark. I could do this fairly easily using Vlookup but I can't figure out how to accommodate students with the same mark. On a simple worksheet the names just overwrite each other, I can't understand how I'd get it formatted like this......

60
59 Wayne
58
57 Bob,Jim,Sarah,Tim
56
55 Alex
54

any ideas? Is it a job for a macro or am I missing something simple

Many thanks
Steve