From: khaled shaheen on 16 May 2010 16:43 Hi all, I badly need your help in the below formula Example: Structure : Account includes Sub-accounts and each sub-account includes dials Formula : Account activation date = Oldest Sub-account activation date where there is more than one account and hence different activation date for each account and in turn the sub-accounts that belong to each account Below the example A B C D Account # Sub-Account # Account Sub-account activation activation date date 2 2.11 ?? 21-01-2010 2 2.12 ?? 26-01-2010 2 2.13 ?? 03-02-2010 3 3.111 ?? 14-02-2010 3 3.112 ?? 29-04-2010 Account Activation date for account#2 shall be 21-01-2010 (Oldest sub-account activation date) Many thanks, Khaled From: Don Guillett on 16 May 2010 17:19 col i has dates,col f dept and do NOT use whole columns An array formula that must be entered using ctrl+shift+enter =MIN(IF((F15:F24=2),I15:I24)) -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "khaled shaheen" wrote in message news:FCB6992B-1C92-4DA8-84BE-7C54F4655A42(a)microsoft.com...> Hi all, > I badly need your help in the below formula > > Example: > Structure : Account includes Sub-accounts and each sub-account includes > dials > > Formula : Account activation date = Oldest Sub-account activation date > where there is more than one account and hence different activation > date for each account and in turn the sub-accounts that belong to each > account > > Below the example > > A B C D > Account # Sub-Account # Account Sub-account > activation activation > date date > > 2 2.11 ?? 21-01-2010 > 2 2.12 ?? 26-01-2010 > 2 2.13 ?? 03-02-2010 > 3 3.111 ?? 14-02-2010 > 3 3.112 ?? 29-04-2010 > > Account Activation date for account#2 shall be 21-01-2010 (Oldest > sub-account activation date) > > Many thanks, > Khaled > >  |  Pages: 1 Prev: Practice Test Using ExcelNext: Conditional Formatting in 2007