Formula that returns all cells with data within a selected range

Hi,

I am trying to find a formula that returns all cells that have data within them as it is a long progress to scroll through and see what data has been entered.

I have attached a workbook with the data.

I basically need a formula that returns all the data without the blank cells in-between. Its so I can easily get a list of which subjects students have been entered for exams.

I hope this makes sense.

I look forward to your help!

Try this ...

=IFERROR(INDEX(A:A,SMALL(IF($A$4:$A$783<>"",ROW($A$4:$A$783),""),ROWS($A$4:A4))),"")

Enter with Ctrl+Shift+Enter.

Thank you very much this seems to have done the trick!