Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Re: Varying cell ranges in formulas according to number of cells with certain value
3 views
Skip to first unread message
Message has been deleted
Claus Busch
May 20, 2013, 7:15:57 AM5/20/13
to
hi,
Am Mon, 20 May 2013 05:10:29 +0100 schrieb Dranoeler:
> A B C D
> Company A User 1 Active
> Company A User 2 Active
> Company A User 3 Inactive
> Company A User 4 Deleted
> Company B User 1 Inactive
> Company B User 2 Active
> Company B User 3 Inactive
select your table => Data => Sort => sort by column C => Custom List =>
New List => List Entries: Active, Inactive, Deleted => Add => Add Level
=> Sort by Colum A => A to Z
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Am Mon, 20 May 2013 05:10:29 +0100 schrieb Dranoeler:
> A B C D
> Company A User 1 Active
> Company A User 2 Active
> Company A User 3 Inactive
> Company A User 4 Deleted
> Company B User 1 Inactive
> Company B User 2 Active
> Company B User 3 Inactive
select your table => Data => Sort => sort by column C => Custom List =>
New List => List Entries: Active, Inactive, Deleted => Add => Add Level
=> Sort by Colum A => A to Z
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
0 new messages