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