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!
Bookmarks