--------------------------------------------
On Tue, 12/13/16, derrickandrew994 via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Average of Columns while excluding certain 
columns
 To: excel-macros@googlegroups.com
 Date: Tuesday, December 13, 2016, 9:00 PM
 
 
 --------------------------------------------
 On Tue, 12/13/16, cronincarmelita via MS EXCEL AND VBA
 MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Average of Columns while
 excluding certain columns
  To: excel-macros@googlegroups.com
  Date: Tuesday, December 13, 2016, 8:37 PM
  
  
  --------------------------------------------
  On Tue, 12/13/16, ashleypartridge via MS EXCEL AND VBA
  MACROS <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Average of Columns
 while
  excluding certain columns
   To: excel-macros@googlegroups.com
   Date: Tuesday, December 13, 2016, 7:18 PM
   
   
   --------------------------------------------
   On Tue, 12/13/16, Paul Schreiner <schreiner_p...@att.net>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ Average of Columns
  while
   excluding certain columns
    To: "excel-macros@googlegroups.com"
   <excel-macros@googlegroups.com>
    Date: Tuesday, December 13, 2016, 6:14 PM
    
    Could
    I get a copy of the sheet?What do you base
    "current" year on, the year
    of "today's" date?(rather
    than a fiscal year or other criteria)
    There are
    several options.But I'd rather not
    try to recreate your data, only to find out my
  creation
    doesn't match
  
 yours! Paul-----------------------------------------
    “Do all the
    good you can,
    By all the means you can,
    In all the ways you can,
    In all
    the places you can,
    At all the times you
    can,
    To all the people you can,
    As long as ever you can.” - John Wesley
    -----------------------------------------
    
    
    
       On Tuesday, December
    13, 2016 11:06 AM, Joseph Carney
    <iosiflu...@gmail.com>
   wrote:
      
    
     
    
    Hello all , 
    I
    have a conundrum.  I have a table that i am using
  to
    collate data from previous years sales.  The data
  is
   from
    2008 thru current year.  I have the table set up as
    follows:Month | 2008 | 2009 | 2009 | 2010 |
    2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 |
  5year
    Average
    Under each of the headings, I
    have a numeric value sorted by month.  What I would
  like
   to
    be able to do is to average the PREVIOUS 5 years
  sales
   while
    ignoring the current year.  Is there a way/formula
  that I
    can set up that would give me the previous 5 year
  average
    without having to manually adjust the formula?
    Thank you for your kind
    assistance,
    Joe
    
    
    
    -- 
    
    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.
    dunarile ad-hoc  1857 . Anii 1853-1858 s-au aratat
   hotaratori si in plan intern. Pasoptistilor
 moldoveni 
   carora li se interzisese de catre domn sa sustina
 cauza
   statului national roman  li se vor adauga si cei
   munteni reintorsi  masiv  in tara  spre
   sfarsitul domniei lui Barbu stirbey.
   
   -- 
   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.onnationalista si a
  conclus un regim neostalinist  caracterizat printr-o
  represiune politica si politieneasca rar intalnita in
 Europa
  contemporana.
  
  -- 
  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.41nt
 ucise si ciopartite in modul cel mai barbar  cand
 muncitorii sunt rapiti de la plugul lor si dusi in sie
 impreuna cu femeile si copiii lor ca in timpul Iu Mahomet
 II  cand intr-un cuvant  vedem patria astra
 amenintata de toate ororile  mvasiunile salbatice din
 secolele trecute  acelas simtamant de jdinta si de
 intelepciune  care ne-a condus totdauna  ne impune
 astazi datoria de a ne ndica cu ii de a tine pept
 pericolului  spre a salva individualitatea politica a
 Statului Roman
 
 -- 
 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.89numai prestigios  ci si incarcat cu o 
valoare simbolica  de model primordial. in pictura romaneasca interbelica 
tematica taraneasca apare  poate  chiar mai frecvent decat in literatura 
epocii. Ea nu are  de regula  nimic dulceag sau pitoresc  dimpotriva  la stefan 
Dumitrescu  la Dimitrie Ghiata  i se asociaza chiar o anumita asprime  
mostenita probabil din pictura lui Ion Andreescu. Ca mii Ressu  Octav Banci a  
Aurel Baesu  Nicolae Tonitza sunt doar cativa dintre pictorii care isi aleg  
adeseori  modelele din randul taranilor sau din mediul de viata al acestora.

-- 
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.

Reply via email to