Creating subsets

[beejay]

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.

 

[Roger Govier]

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 Columns>Sort (using your original column)>ascending
Delete the rows below the last entry in your original column.
Select Both Columns>Sort (using helper column)>Ascending
Delete helper column.