Hi, all.
I have a simple question.

I have:
---------------------------------------
1 Nick L x x x Single
2 John B x x x Married
.
.
40 Rob C x x x Single
----------------------------------------

I want to create a separate TAB ..

but

I want the "singles" to be on top (automatically with vlookups)

AND
the Married on a different table..

In practice ..

it should say something like find "singles" and included it in my top table ..for "married" include it in my bottom table!..

But to make a list again wouldn t it be like find the first single...add to the list..find the next and add to the next raw.......


Can this be done??



the data are obviously not the actual but the idea is the same (think of products and unique names!)