--------------------------------------------
On Tue, 12/13/16, libertystringer 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:18 PM
 
 
 --------------------------------------------
 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.curtu  loan  Bulei  Ion  Democratia la 
romani  1866-1938  Editura Humanitas  Bucuresti  1990.Scurtu  loan  Contributii 
privind viata politica din Romania. Evolutia formei de guvernamant in istoria

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