In I1 type name
J1: status
J2: single

select A:B

Goto Data.FilterAdvanced Filter

click the Copy to another location button

In Criteria, select I1:J2

In Copy To select C1:D1

OK

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"martin" wrote in message
...
thanks! :)

but do you have a formula or something like index(....).

im not sure though.

thanks again.

--
technical newbie


"Ardus Petus" wrote:

Use DataFilterAdvanced filter or Automatic filter

HTH
--
AP

"martin" a écrit dans le message de
news:
...
if i have this table:

name status
cris single
jasper single
apple married
rd single
jojo married

how can i create a new column that will show all single persons lined
up
at
the top. and would look like this.

NAME STATUS QUERY
cris single cris
jasper single jasper
apple married rd
rd single
jojo married

thanks in advance


--
technical newbie