Most frequently occuring text including empy cells

Hello everyone!

So I am making an excel file to track the books I've read and calculate some statistics about it.
One of the stats I want Excel to calculate is most read author. For this problem, I've found the following formula:

=INDEX(Range;MODE(MATCH(Range;Range;0)))

This formula works perfectly if the range covers al the cells currently in use. In the example file this would be

=INDEX(B2:B14;MODE(MATCH(B2:B14;B2:B14;0)))

However, I want to keep adding books I've read during the year. So I want it to compute the most frequently used text in a bigger range of cells I can use for future books, for example:

=INDEX(B2:B150;MODE(MATCH(B2:B150;B2:B150;0)))

This is where the problem starts. When there is one or more empty cells in the range, it returns a #N/A error.

Is there any way I can make this formula work without having to change the range every time I add a new book? I was thinking maybe there is a way to set the range to B2:'the furthest non-empty cell within collumn B', but I don't know if that is possible. Maybe a totally different formula is required.

Thanks in advance.