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)

"martin" <martin@discussions.microsoft.com> wrote in message
news:1789A842-AD02-4921-B182-459B97B9DCAC@microsoft.com...
> thanks!
>
> but do you have a formula or something like index(....).
>
> im not sure though.
>
> thanks again.
>
> --
> technical newbie
>
>
> "Ardus Petus" wrote:
>
> > Use Data>Filter>Advanced filter or Automatic filter
> >
> > HTH
> > --
> > AP
> >
> > "martin" <martin@discussions.microsoft.com> a écrit dans le message de
news:
> > E6AF338C-82FD-42FB-BACD-9A5F630134D4@microsoft.com...
> > > 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
> >
> >
> >