auto fill column without blank rows

Hithere,

I can't figure out the following. (example sheet attached)

When filling column A in sheet "result" with filtered data from column A in sheet "data" with an IF > 5 formula, this results in several blank rows.

I would like the outcome to be like column B (sheet "result")
Preferrably fully automated, without pulling down formula's over several cells, or removing blank rows afterwards.

Can it be done?

Tia!

just sort column A ascending with "headers"--see help on sort

Thanks!

I have no time the coming days to put my teeth in this method, but this looks very promising.

If I can make it work this way; thanks again, otherwise: i'll be back ;-)

=small($a$2:$a$24,row()-1)

My bad. I didn't read the entire question. In that case I would probably use pivot table or excel vba..