Varying cell ranges in formulas according to number of cells with certain value
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
|