automatic sorting names based on numerical data

Hi,

I am trying to create an assessment spreadsheet. Next to a name, a mark is given in a number format. Depending on what mark is given, it will then place the name under the corresponding mark heading in alphabetical order. I'd like this to happen in the same sheet and I would also like to know how make this copy to another sheet.

I understand some formulas but don't know much about VBA or Macros but I wondered if these would allow me to achieve my end goal more effectively or if using formulas is best.

Another user suggested using =IFERROR(INDEX($A:$A,SMALL(INDEX(($G$6:$G$29<>P$5)*10^10+ROW($G$6:$G$29),0),ROW(1:1))),"")
This works well although it leaves cells that = 0 in the rows underneath meaning you can't have another set of results underneath that is close enough to compare.

It would make more sense by looking at the example attached. The 'suggestion' sheet is what the other user suggested and 'what I would like' explains itself.

Any help would be greatly appreciated.

Thanks

Thanks for your help Ford,

If I understand correctly '5SL Writing Summary' and 'Dec 2013' could be in different rows, that wouldn't matter at all.

After putting in your formula I'm not sure that it solves my issue of having cells in the rows below all the names that contain a formula or 0 therefore I'm unable to have another set of results closely underneath like the example of what I want. It may have been the way that I input the data but under the 0 heading, the first 6 cells returned 0.

Thanks for you assistance

Simon