View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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