I have a spreadsheet which contains people's names and numbers associated
with those people. I would like to set it up so if the number is greater
than 5 then excel will copy the name into a different list. I can do this
with IF statements but i get lots of blank cells where that person does not
fill the criteria.

Any ideas how to solve this????