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