Hi

If you don't mind having your list sorted, then Sorting is the easiest way.
All the blanks will go to the bottom.

If you need to keep the order, then create a helper column first, numbered
1,2,3 ..... etc
Select Both ColumnsSort (using your original column)ascending
Delete the rows below the last entry in your original column.
Select Both ColumnsSort (using helper column)Ascending
Delete helper column.
--
Regards
Roger Govier

"beejay" wrote in message
...
I have created a list from which I wish to create subset on a separate
worksheet. i have created a suitable formula to achieve this. My problem
is
that in creating the subset I can find no way of removing blank rows from
my
subset so that there are no gaps in my new list. Any ideas/formulas.