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 also in another sheet. I have the currently used the following formula =IF(G6=8.5,A6,0). This has done what I would like but there are 0's in between the names. I'd like no zero's and no spaces between names. I have attached my document, 'Test' is what I tried to do and 'What i would like' is how I'd like it to appear. I know how to use formulas but I think this may require more technical advice. Any advice would be greatly appreciated. Thank you

Hi Littlesimon,

Welcome to the forum!

Try this formula =IF($G6=P$5,$A6,"")

Regards,
AM

Hi AM,
Thank you for your help. If I implemented this correctly it returns a blank cell if the criteria is not met. This is a step closer to what I am after. Is there any way to sort the columns into alphabetical order automatically or remove the blank cells in between cells automatically or copy it to another location without the blank cells in between? Thanks again for your assistance.

Thanks nflsales,

Your idea worked to do exactly what I wanted in less steps. My only problem is I would like to bee able to see the results for the 3 different times of year 'end 2013', 'mid 2014' and 'end 2014' on the same page. In it's current form it takes up quite a bit of space on the page as there are numerous cells that return 0's under the names. Would there be any way of doing this? I have attached another document with what I am after. These may also have to be copied to other sheets.

Any help is greatly appreciated.

Simon