Re: $$Excel-Macros$$ advanced formula

2017-04-17 Thread 'Carmelita Cronin' via MS EXCEL AND VBA MACROS 


On Tue, 4/18/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ advanced formula
 To: excel-macros@googlegroups.com
 Date: Tuesday, April 18, 2017, 3:12 AM
 
 
 
 On Tue, 4/18/17, 'Regine Silvers' via
 MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ advanced
 formula
  To: excel-macros@googlegroups.com
  Date: Tuesday, April 18, 2017, 1:03
 AM
  
  
 
 
  On Mon, 4/17/17, 'Martin George' via
 MS
  EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 advanced
  formula
   To: excel-macros@googlegroups.com
   Date: Monday, April 17, 2017,
 11:14
  PM
   
   
  
 
 
   On Mon, 4/17/17, 'Liberty
 Stringer'
  via
   MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$
  advanced
   formula
    To: excel-macros@googlegroups.com
    Date: Monday, April 17, 2017,
  8:44 PM
    
    
   
  
 
 
    On Mon, 4/17/17, 'Minta Spriggs'
  via
   MS
    EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re:
 $$Excel-Macros$$
   advanced
    formula
     To: excel-macros@googlegroups.com
     Date: Monday, April 17,
 2017,
   6:56 PM
     
     
    
   
  
 
 
     On Mon, 4/17/17, Swapnil
   Palande
    <palande.swapni...@gmail.com>
     wrote:
     
      Subject: Re:
  $$Excel-Macros$$
    advanced
     formula
      To: excel-macros@googlegroups.com
      Date: Monday, April 17,
  2017,
    1:01 PM
      
      Hi,
      
      Check attached solution.
      
      Regards,
      Swapnil Suresh Palande
      
      On Mon, Apr 17, 2017 at
      9:38 AM, GENIUS <izharra...@gmail.com>
      wrote:
      Thank you very much for your
    help, can
     you please
      do it through formula because
  if
    you
     see my question
      I've mentioned use formula
    instead
     pivot table.
      
      
      
      
      -- 
      
      Are you =EXP(E:RT) or
    =NOT(EXP(E:RT))
     in Excel? And do you
      wanna be? It’s
    =TIME(2,DO:IT,N:OW) !
     Join official
      Facebook page of this forum @
  https://www.facebook.com/
      discussexcel
      
       
      
      FORUM RULES
      
       
      
      1) Use concise, accurate
  thread
     titles. Poor thread titles,
      like Please Help, Urgent,
  Need
    Help,
     Formula Problem, Code
      Problem, and Need Advice
  will
    not get
     quick attention or may
      not be answered.
      
      2) Don't post a question in
  the
    thread
     of another
      member.
      
      3) Don't post questions
    regarding
     breaking or bypassing
      any security measure.
      
      4) Acknowledge the responses
    you
     receive, good or bad.
      
      5) Jobs posting is not
  allowed.
      
      6) Sharing copyrighted
  material
    and
     their links is not
      allowed.
      
       
      
      NOTE  : Don't ever post
     confidential data in a
   workbook.
      Forum owners and members are
    not
     responsible for any
      loss.
      
      --- 
      
      You received this message
    because you
     are subscribed to the
      Google Groups "MS EXCEL AND
  VBA
     MACROS" group.
      
      To unsubscribe from this
  group
    and
     stop receiving emails
      from it, send an email to
     excel-macros+unsubscribe@
      googlegroups.com.
      
      To post to this group, send
    email to
     excel-macros@googlegroups.com.
      
      Visit this group at https://groups.google.com/
      group/excel-macros.
      
      For more options, visit https://groups.google.com/d/
      optout.
      
      
      
      
      
      
      -- 
      
      Are you =EXP(E:RT) or
    =NOT(EXP(E:RT))
     in Excel? And do you
      wanna be? It’s
    =TIME(2,DO:IT,N:OW) !
     Join official
      Facebook page of this forum @
  https://www.facebook.com/discussexcel
      
       
      
      FORUM RULES
      
       
      
      1) Use concise, accurate
  thread
     titles. Poor thread titles,
      like Please Help, Urgent,
  Need
    Help,
     Formula Problem, Code
      Problem, and Need Advice
  will
    not get
     quick attention or may
      not be answered.
      
      2) Don't post a question in
  the
    thread
     of another
      member.
      
      3) Don't post questions
    regarding
     breaking or bypassing
      any security measure.
      
      4) Acknowledge the responses
    you
     receive, good or bad.
      
      5) Jobs posting is not
  allowed.
      
      6) Sharing copyrighted
  ma

Re: $$Excel-Macros$$ advanced formula

2017-04-17 Thread 'Kenyatta Freed' via MS EXCEL AND VBA MACROS 


On Tue, 4/18/17, 'Regine Silvers' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ advanced formula
 To: excel-macros@googlegroups.com
 Date: Tuesday, April 18, 2017, 1:03 AM
 
 
 
 On Mon, 4/17/17, 'Martin George' via MS
 EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ advanced
 formula
  To: excel-macros@googlegroups.com
  Date: Monday, April 17, 2017, 11:14
 PM
  
  
 
 
  On Mon, 4/17/17, 'Liberty Stringer'
 via
  MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 advanced
  formula
   To: excel-macros@googlegroups.com
   Date: Monday, April 17, 2017,
 8:44 PM
   
   
  
 
 
   On Mon, 4/17/17, 'Minta Spriggs'
 via
  MS
   EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$
  advanced
   formula
    To: excel-macros@googlegroups.com
    Date: Monday, April 17, 2017,
  6:56 PM
    
    
   
  
 
 
    On Mon, 4/17/17, Swapnil
  Palande
   <palande.swapni...@gmail.com>
    wrote:
    
     Subject: Re:
 $$Excel-Macros$$
   advanced
    formula
     To: excel-macros@googlegroups.com
     Date: Monday, April 17,
 2017,
   1:01 PM
     
     Hi,
     
     Check attached solution.
     
     Regards,
     Swapnil Suresh Palande
     
     On Mon, Apr 17, 2017 at
     9:38 AM, GENIUS <izharra...@gmail.com>
     wrote:
     Thank you very much for your
   help, can
    you please
     do it through formula because
 if
   you
    see my question
     I've mentioned use formula
   instead
    pivot table.
     
     
     
     
     -- 
     
     Are you =EXP(E:RT) or
   =NOT(EXP(E:RT))
    in Excel? And do you
     wanna be? It’s
   =TIME(2,DO:IT,N:OW) !
    Join official
     Facebook page of this forum @
 https://www.facebook.com/
     discussexcel
     
      
     
     FORUM RULES
     
      
     
     1) Use concise, accurate
 thread
    titles. Poor thread titles,
     like Please Help, Urgent,
 Need
   Help,
    Formula Problem, Code
     Problem, and Need Advice
 will
   not get
    quick attention or may
     not be answered.
     
     2) Don't post a question in
 the
   thread
    of another
     member.
     
     3) Don't post questions
   regarding
    breaking or bypassing
     any security measure.
     
     4) Acknowledge the responses
   you
    receive, good or bad.
     
     5) Jobs posting is not
 allowed.
     
     6) Sharing copyrighted
 material
   and
    their links is not
     allowed.
     
      
     
     NOTE  : Don't ever post
    confidential data in a
  workbook.
     Forum owners and members are
   not
    responsible for any
     loss.
     
     --- 
     
     You received this message
   because you
    are subscribed to the
     Google Groups "MS EXCEL AND
 VBA
    MACROS" group.
     
     To unsubscribe from this
 group
   and
    stop receiving emails
     from it, send an email to
    excel-macros+unsubscribe@
     googlegroups.com.
     
     To post to this group, send
   email to
    excel-macros@googlegroups.com.
     
     Visit this group at https://groups.google.com/
     group/excel-macros.
     
     For more options, visit https://groups.google.com/d/
     optout.
     
     
     
     
     
     
     -- 
     
     Are you =EXP(E:RT) or
   =NOT(EXP(E:RT))
    in Excel? And do you
     wanna be? It’s
   =TIME(2,DO:IT,N:OW) !
    Join official
     Facebook page of this forum @
 https://www.facebook.com/discussexcel
     
      
     
     FORUM RULES
     
      
     
     1) Use concise, accurate
 thread
    titles. Poor thread titles,
     like Please Help, Urgent,
 Need
   Help,
    Formula Problem, Code
     Problem, and Need Advice
 will
   not get
    quick attention or may
     not be answered.
     
     2) Don't post a question in
 the
   thread
    of another
     member.
     
     3) Don't post questions
   regarding
    breaking or bypassing
     any security measure.
     
     4) Acknowledge the responses
   you
    receive, good or bad.
     
     5) Jobs posting is not
 allowed.
     
     6) Sharing copyrighted
 material
   and
    their links is not
     allowed.
     
      
     
     NOTE  : Don't ever post
    confidential data in a
  workbook.
     Forum owners and members are
   not
    responsible for any
     loss.
     
     --- 
     
     You received this message
   because you
    are subscribed to the
     Google Groups "MS EXCEL AND
 VBA
    MACROS" group.
     
     To unsubscribe from this
 group
   and
    stop receiving emails
     from it, send an email to
    excel-macros+unsubscr...@googlegroups.com.
     
     To post to this g

Re: $$Excel-Macros$$ advanced formula

2017-04-17 Thread 'Regine Silvers' via MS EXCEL AND VBA MACROS 


On Mon, 4/17/17, 'Martin George' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ advanced formula
 To: excel-macros@googlegroups.com
 Date: Monday, April 17, 2017, 11:14 PM
 
 
 
 On Mon, 4/17/17, 'Liberty Stringer' via
 MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ advanced
 formula
  To: excel-macros@googlegroups.com
  Date: Monday, April 17, 2017, 8:44 PM
  
  
 
 
  On Mon, 4/17/17, 'Minta Spriggs' via
 MS
  EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 advanced
  formula
   To: excel-macros@googlegroups.com
   Date: Monday, April 17, 2017,
 6:56 PM
   
   
  
 
 
   On Mon, 4/17/17, Swapnil
 Palande
  <palande.swapni...@gmail.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$
  advanced
   formula
    To: excel-macros@googlegroups.com
    Date: Monday, April 17, 2017,
  1:01 PM
    
    Hi,
    
    Check attached solution.
    
    Regards,
    Swapnil Suresh Palande
    
    On Mon, Apr 17, 2017 at
    9:38 AM, GENIUS <izharra...@gmail.com>
    wrote:
    Thank you very much for your
  help, can
   you please
    do it through formula because if
  you
   see my question
    I've mentioned use formula
  instead
   pivot table.
    
    
    
    
    -- 
    
    Are you =EXP(E:RT) or
  =NOT(EXP(E:RT))
   in Excel? And do you
    wanna be? It’s
  =TIME(2,DO:IT,N:OW) !
   Join official
    Facebook page of this forum @ https://www.facebook.com/
    discussexcel
    
     
    
    FORUM RULES
    
     
    
    1) Use concise, accurate thread
   titles. Poor thread titles,
    like Please Help, Urgent, Need
  Help,
   Formula Problem, Code
    Problem, and Need Advice will
  not get
   quick attention or may
    not be answered.
    
    2) Don't post a question in the
  thread
   of another
    member.
    
    3) Don't post questions
  regarding
   breaking or bypassing
    any security measure.
    
    4) Acknowledge the responses
  you
   receive, good or bad.
    
    5) Jobs posting is not allowed.
    
    6) Sharing copyrighted material
  and
   their links is not
    allowed.
    
     
    
    NOTE  : Don't ever post
   confidential data in a
 workbook.
    Forum owners and members are
  not
   responsible for any
    loss.
    
    --- 
    
    You received this message
  because you
   are subscribed to the
    Google Groups "MS EXCEL AND VBA
   MACROS" group.
    
    To unsubscribe from this group
  and
   stop receiving emails
    from it, send an email to
   excel-macros+unsubscribe@
    googlegroups.com.
    
    To post to this group, send
  email to
   excel-macros@googlegroups.com.
    
    Visit this group at https://groups.google.com/
    group/excel-macros.
    
    For more options, visit https://groups.google.com/d/
    optout.
    
    
    
    
    
    
    -- 
    
    Are you =EXP(E:RT) or
  =NOT(EXP(E:RT))
   in Excel? And do you
    wanna be? It’s
  =TIME(2,DO:IT,N:OW) !
   Join official
    Facebook page of this forum @ https://www.facebook.com/discussexcel
    
     
    
    FORUM RULES
    
     
    
    1) Use concise, accurate thread
   titles. Poor thread titles,
    like Please Help, Urgent, Need
  Help,
   Formula Problem, Code
    Problem, and Need Advice will
  not get
   quick attention or may
    not be answered.
    
    2) Don't post a question in the
  thread
   of another
    member.
    
    3) Don't post questions
  regarding
   breaking or bypassing
    any security measure.
    
    4) Acknowledge the responses
  you
   receive, good or bad.
    
    5) Jobs posting is not allowed.
    
    6) Sharing copyrighted material
  and
   their links is not
    allowed.
    
     
    
    NOTE  : Don't ever post
   confidential data in a
 workbook.
    Forum owners and members are
  not
   responsible for any
    loss.
    
    --- 
    
    You received this message
  because you
   are subscribed to the
    Google Groups "MS EXCEL AND VBA
   MACROS" group.
    
    To unsubscribe from this group
  and
   stop receiving emails
    from it, send an email to
   excel-macros+unsubscr...@googlegroups.com.
    
    To post to this group, send
  email to
   excel-macros@googlegroups.com.
    
    Visit this group at
  
 
 https://groups.google.com/group/excel-macros.
    
    For more options, visit
  
 https://groups.google.com/d/optout.
    egaturile cu romanii din Vechiul
  Regat
   au continuat cu intensitate.
  irsonalitati ale culturii
   romanesti  ca Nicolae  orga 
 Ar st
  ta
   Romanescu  Ion https://www.facebook.com/discussexcel
   
   FORUM RULES
   
   1) Use concise, accurate thread
  titles.
   Poor thread titles, like Please
 Help,
  Urgent, Need Help,
  

Re: $$Excel-Macros$$ advanced formula

2017-04-17 Thread 'Martin George' via MS EXCEL AND VBA MACROS 


On Mon, 4/17/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ advanced formula
 To: excel-macros@googlegroups.com
 Date: Monday, April 17, 2017, 8:44 PM
 
 
 
 On Mon, 4/17/17, 'Minta Spriggs' via MS
 EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ advanced
 formula
  To: excel-macros@googlegroups.com
  Date: Monday, April 17, 2017, 6:56 PM
  
  
 
 
  On Mon, 4/17/17, Swapnil Palande
 <palande.swapni...@gmail.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 advanced
  formula
   To: excel-macros@googlegroups.com
   Date: Monday, April 17, 2017,
 1:01 PM
   
   Hi,
   
   Check attached solution.
   
   Regards,
   Swapnil Suresh Palande
   
   On Mon, Apr 17, 2017 at
   9:38 AM, GENIUS <izharra...@gmail.com>
   wrote:
   Thank you very much for your
 help, can
  you please
   do it through formula because if
 you
  see my question
   I've mentioned use formula
 instead
  pivot table.
   
   
   
   
   -- 
   
   Are you =EXP(E:RT) or
 =NOT(EXP(E:RT))
  in Excel? And do you
   wanna be? It’s
 =TIME(2,DO:IT,N:OW) !
  Join official
   Facebook page of this forum @ https://www.facebook.com/
   discussexcel
   
    
   
   FORUM RULES
   
    
   
   1) Use concise, accurate thread
  titles. Poor thread titles,
   like Please Help, Urgent, Need
 Help,
  Formula Problem, Code
   Problem, and Need Advice will
 not get
  quick attention or may
   not be answered.
   
   2) Don't post a question in the
 thread
  of another
   member.
   
   3) Don't post questions
 regarding
  breaking or bypassing
   any security measure.
   
   4) Acknowledge the responses
 you
  receive, good or bad.
   
   5) Jobs posting is not allowed.
   
   6) Sharing copyrighted material
 and
  their links is not
   allowed.
   
    
   
   NOTE  : Don't ever post
  confidential data in a workbook.
   Forum owners and members are
 not
  responsible for any
   loss.
   
   --- 
   
   You received this message
 because you
  are subscribed to the
   Google Groups "MS EXCEL AND VBA
  MACROS" group.
   
   To unsubscribe from this group
 and
  stop receiving emails
   from it, send an email to
  excel-macros+unsubscribe@
   googlegroups.com.
   
   To post to this group, send
 email to
  excel-macros@googlegroups.com.
   
   Visit this group at https://groups.google.com/
   group/excel-macros.
   
   For more options, visit https://groups.google.com/d/
   optout.
   
   
   
   
   
   
   -- 
   
   Are you =EXP(E:RT) or
 =NOT(EXP(E:RT))
  in Excel? And do you
   wanna be? It’s
 =TIME(2,DO:IT,N:OW) !
  Join official
   Facebook page of this forum @ https://www.facebook.com/discussexcel
   
    
   
   FORUM RULES
   
    
   
   1) Use concise, accurate thread
  titles. Poor thread titles,
   like Please Help, Urgent, Need
 Help,
  Formula Problem, Code
   Problem, and Need Advice will
 not get
  quick attention or may
   not be answered.
   
   2) Don't post a question in the
 thread
  of another
   member.
   
   3) Don't post questions
 regarding
  breaking or bypassing
   any security measure.
   
   4) Acknowledge the responses
 you
  receive, good or bad.
   
   5) Jobs posting is not allowed.
   
   6) Sharing copyrighted material
 and
  their links is not
   allowed.
   
    
   
   NOTE  : Don't ever post
  confidential data in a workbook.
   Forum owners and members are
 not
  responsible for any
   loss.
   
   --- 
   
   You received this message
 because you
  are subscribed to the
   Google Groups "MS EXCEL AND VBA
  MACROS" group.
   
   To unsubscribe from this group
 and
  stop receiving emails
   from it, send an email to
  excel-macros+unsubscr...@googlegroups.com.
   
   To post to this group, send
 email to
  excel-macros@googlegroups.com.
   
   Visit this group at
 
 https://groups.google.com/group/excel-macros.
   
   For more options, visit
  https://groups.google.com/d/optout.
   egaturile cu romanii din Vechiul
 Regat
  au continuat cu intensitate.
 irsonalitati ale culturii
  romanesti  ca Nicolae  orga  Ar st
 ta
  Romanescu  Ion https://www.facebook.com/discussexcel
  
  FORUM RULES
  
  1) Use concise, accurate thread
 titles.
  Poor thread titles, like Please Help,
 Urgent, Need Help,
  Formula Problem, Code Problem, and
 Need Advice will not get
  quick attention or may not be
 answered.
  2) Don't post a question in the
 thread
  of another member.
  3) Don't post questions regarding
  breaking or bypassing any security
 measure.
  4) Acknowledge the responses you
  receive, good or bad.
  5) Jobs posting is not allowed.
  6) Sharing copyrighted material and
  their links is not allowed.
  
  NOTE  : Don't ever post
  confidential data in a workbook. Forum
 owners and members
  are not responsible for

Re: $$Excel-Macros$$ advanced formula

2017-04-17 Thread 'Liberty Stringer' via MS EXCEL AND VBA MACROS 


On Mon, 4/17/17, 'Minta Spriggs' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ advanced formula
 To: excel-macros@googlegroups.com
 Date: Monday, April 17, 2017, 6:56 PM
 
 
 
 On Mon, 4/17/17, Swapnil Palande <palande.swapni...@gmail.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ advanced
 formula
  To: excel-macros@googlegroups.com
  Date: Monday, April 17, 2017, 1:01 PM
  
  Hi,
  
  Check attached solution.
  
  Regards,
  Swapnil Suresh Palande
  
  On Mon, Apr 17, 2017 at
  9:38 AM, GENIUS <izharra...@gmail.com>
  wrote:
  Thank you very much for your help, can
 you please
  do it through formula because if you
 see my question
  I've mentioned use formula instead
 pivot table.
  
  
  
  
  -- 
  
  Are you =EXP(E:RT) or =NOT(EXP(E:RT))
 in Excel? And do you
  wanna be? It’s =TIME(2,DO:IT,N:OW) !
 Join official
  Facebook page of this forum @ https://www.facebook.com/
  discussexcel
  
   
  
  FORUM RULES
  
   
  
  1) Use concise, accurate thread
 titles. Poor thread titles,
  like Please Help, Urgent, Need Help,
 Formula Problem, Code
  Problem, and Need Advice will not get
 quick attention or may
  not be answered.
  
  2) Don't post a question in the thread
 of another
  member.
  
  3) Don't post questions regarding
 breaking or bypassing
  any security measure.
  
  4) Acknowledge the responses you
 receive, good or bad.
  
  5) Jobs posting is not allowed.
  
  6) Sharing copyrighted material and
 their links is not
  allowed.
  
   
  
  NOTE  : Don't ever post
 confidential data in a workbook.
  Forum owners and members are not
 responsible for any
  loss.
  
  --- 
  
  You received this message because you
 are subscribed to the
  Google Groups "MS EXCEL AND VBA
 MACROS" group.
  
  To unsubscribe from this group and
 stop receiving emails
  from it, send an email to
 excel-macros+unsubscribe@
  googlegroups.com.
  
  To post to this group, send email to
 excel-macros@googlegroups.com.
  
  Visit this group at https://groups.google.com/
  group/excel-macros.
  
  For more options, visit https://groups.google.com/d/
  optout.
  
  
  
  
  
  
  -- 
  
  Are you =EXP(E:RT) or =NOT(EXP(E:RT))
 in Excel? And do you
  wanna be? It’s =TIME(2,DO:IT,N:OW) !
 Join official
  Facebook page of this forum @ https://www.facebook.com/discussexcel
  
   
  
  FORUM RULES
  
   
  
  1) Use concise, accurate thread
 titles. Poor thread titles,
  like Please Help, Urgent, Need Help,
 Formula Problem, Code
  Problem, and Need Advice will not get
 quick attention or may
  not be answered.
  
  2) Don't post a question in the thread
 of another
  member.
  
  3) Don't post questions regarding
 breaking or bypassing
  any security measure.
  
  4) Acknowledge the responses you
 receive, good or bad.
  
  5) Jobs posting is not allowed.
  
  6) Sharing copyrighted material and
 their links is not
  allowed.
  
   
  
  NOTE  : Don't ever post
 confidential data in a workbook.
  Forum owners and members are not
 responsible for any
  loss.
  
  --- 
  
  You received this message because you
 are subscribed to the
  Google Groups "MS EXCEL AND VBA
 MACROS" group.
  
  To unsubscribe from this group and
 stop receiving emails
  from it, send an email to
 excel-macros+unsubscr...@googlegroups.com.
  
  To post to this group, send email to
 excel-macros@googlegroups.com.
  
  Visit this group at
 https://groups.google.com/group/excel-macros.
  
  For more options, visit
 https://groups.google.com/d/optout.
  egaturile cu romanii din Vechiul Regat
 au continuat cu intensitate. irsonalitati ale culturii
 romanesti  ca Nicolae  orga  Ar st ta
 Romanescu  Ion https://www.facebook.com/discussexcel
 
 FORUM RULES
 
 1) Use concise, accurate thread titles.
 Poor thread titles, like Please Help, Urgent, Need Help,
 Formula Problem, Code Problem, and Need Advice will not get
 quick attention or may not be answered.
 2) Don't post a question in the thread
 of another member.
 3) Don't post questions regarding
 breaking or bypassing any security measure.
 4) Acknowledge the responses you
 receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and
 their links is not allowed.
 
 NOTE  : Don't ever post
 confidential data in a workbook. Forum owners and members
 are not responsible for any loss.
 --- 
 You received this message because you
 are subscribed to the Google Groups "MS EXCEL AND VBA
 MACROS" group.
 To unsubscribe from this group and stop
 receiving emails from it, send an email to 
excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at
 https://groups.google.com/group/excel-macros.
 For more options, visit
 https://groups.google.com/d/optout. Veacului al XIX-lea. in plus  remarcam 
coreligionarii ortodocsi de rit

Re: $$Excel-Macros$$ advanced formula

2017-04-17 Thread 'Minta Spriggs' via MS EXCEL AND VBA MACROS 


On Mon, 4/17/17, Swapnil Palande <palande.swapni...@gmail.com> wrote:

 Subject: Re: $$Excel-Macros$$ advanced formula
 To: excel-macros@googlegroups.com
 Date: Monday, April 17, 2017, 1:01 PM
 
 Hi,
 
 Check attached solution.
 
 Regards,
 Swapnil Suresh Palande
 
 On Mon, Apr 17, 2017 at
 9:38 AM, GENIUS <izharra...@gmail.com>
 wrote:
 Thank you very much for your help, can you please
 do it through formula because if you see my question
 I've mentioned use formula instead pivot table.
 
 
 
 
 -- 
 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/
 discussexcel
 
  
 
 FORUM RULES
 
  
 
 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.
 
 2) Don't post a question in the thread of another
 member.
 
 3) Don't post questions regarding breaking or bypassing
 any security measure.
 
 4) Acknowledge the responses you receive, good or bad.
 
 5) Jobs posting is not allowed.
 
 6) Sharing copyrighted material and their links is not
 allowed.
 
  
 
 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any
 loss.
 
 --- 
 
 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.
 
 To unsubscribe from this group and stop receiving emails
 from it, send an email to excel-macros+unsubscribe@
 googlegroups.com.
 
 To post to this group, send email to excel-macros@googlegroups.com.
 
 Visit this group at https://groups.google.com/
 group/excel-macros.
 
 For more options, visit https://groups.google.com/d/
 optout.
 
 
 
 
 
 
 -- 
 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discussexcel
 
  
 
 FORUM RULES
 
  
 
 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.
 
 2) Don't post a question in the thread of another
 member.
 
 3) Don't post questions regarding breaking or bypassing
 any security measure.
 
 4) Acknowledge the responses you receive, good or bad.
 
 5) Jobs posting is not allowed.
 
 6) Sharing copyrighted material and their links is not
 allowed.
 
  
 
 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any
 loss.
 
 --- 
 
 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.
 
 To unsubscribe from this group and stop receiving emails
 from it, send an email to excel-macros+unsubscr...@googlegroups.com.
 
 To post to this group, send email to excel-macros@googlegroups.com.
 
 Visit this group at https://groups.google.com/group/excel-macros.
 
 For more options, visit https://groups.google.com/d/optout.
 egaturile cu romanii din Vechiul Regat au continuat cu intensitate. 
irsonalitati ale culturii romanesti  ca Nicolae  orga  Ar st ta Romanescu  Ion 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ advanced formula

2017-04-17 Thread GENIUS 
Thank you Mr Swapnil Palande 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ advanced formula

2017-04-17 Thread Swapnil Palande 
Hi,

Check attached solution.

Regards,
Swapnil Suresh Palande

On Mon, Apr 17, 2017 at 9:38 AM, GENIUS  wrote:

> Thank you very much for your help, can you please do it through formula
> because if you see my question I've mentioned use formula instead pivot
> table.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


advanced formula_solution.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ advanced formula

2017-04-16 Thread 'Martin George' via MS EXCEL AND VBA MACROS 


On Mon, 4/17/17, GENIUS <izharra...@gmail.com> wrote:

 Subject: Re: $$Excel-Macros$$ advanced formula
 To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com>
 Date: Monday, April 17, 2017, 6:08 AM
 
 Thank you
 very much for your help, can you please do it through
 formula because if you see my question I've mentioned
 use formula instead pivot table.
 
 
 
 
 -- 
 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discussexcel
 
  
 
 FORUM RULES
 
  
 
 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.
 
 2) Don't post a question in the thread of another
 member.
 
 3) Don't post questions regarding breaking or bypassing
 any security measure.
 
 4) Acknowledge the responses you receive, good or bad.
 
 5) Jobs posting is not allowed.
 
 6) Sharing copyrighted material and their links is not
 allowed.
 
  
 
 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any
 loss.
 
 --- 
 
 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.
 
 To unsubscribe from this group and stop receiving emails
 from it, send an email to excel-macros+unsubscr...@googlegroups.com.
 
 To post to this group, send email to excel-macros@googlegroups.com.
 
 Visit this group at https://groups.google.com/group/excel-macros.
 
 For more options, visit https://groups.google.com/d/optout.
 acsimilul ultimei pagini a Dictatului de la Viena

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ advanced formula

2017-04-16 Thread GENIUS 
Thank you very much for your help, can you please do it through formula 
because if you see my question I've mentioned use formula instead pivot 
table.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ advanced formula

2017-04-14 Thread Izhar 
please see the question in the attachment

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


question.xlsx
Description: MS-Excel 2007 spreadsheet