question for indexing a table

M

martin

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
 
M

martin

thanks! :)

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

im not sure though.

thanks again.
 
B

Bob Phillips

In I1 type name
J1: status
J2: single

select A:B

Goto Data.Filter>Advanced 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)
 
Top