Hi

data is age in years and months. I've used text to columns to provide two
columns of data - A = years and B = months.

The data is not contiguous and I have been using autofilter on similar
spreadsheets to check blanks and #num etc so that I don't have to go through
all data.

That's been working well until today when autofilter seems to be filtering
only part of the column until it reaches a blank cell.

could anyone tell me why it's doing this and if there is a fix.

Probably being dense but this was only supposed to be a small part of work
and now seems a major blockage aaaaghh

TIA
--
Smudge