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