Hi there,

I have a table which contains lines with sales leads and information such as sale stage, eg:

prospect name1 ...
prospect name2 ...
suspect name3 ...
prospect name4 ...
suspect name5 ....

I would like to extract on another sheet subsets of this table based on a column info (eg first column):

prospect name1 ...
prospect name2 ...
prospect name4 ...

or

suspect name3 ...
suspect name5 ....


I would rather not do this with a pivot table as I then need to play quite a bit with this, and also that table itself is reconstructed from other pages. What formula shall I use to achieve this?

thx