question for indexing a table

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

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

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
>
>
>

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
> >
> >
> >