Hi,On 2002-09-10 03:15, hughp wrote:
Thanks for the suggestion.I'd like to keep the year data numeric rathar than date or text.I have removed blanks from raw data but still the grouping defies me.
hughp
Book1 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Year | YrGroup | Approach1 | Approach2 | |||||||
2 | 2001 | 2001 | |||||||||
3 | 2002 | 2002 | CountofYear | CountofYrGroup | |||||||
4 | 2003 | 2003 | Year | Total | YrGroup | Total | |||||
5 | 2004 | 2004 | 2001-2005 | 5 | 2001 | 1 | |||||
6 | 2005 | 2005 | 2006-2010 | 5 | 2002 | 1 | |||||
7 | 2006 | 2006 | 2011-2015 | 5 | 2003 | 1 | |||||
8 | 2007 | 2007 | 2016-2020 | 5 | 2004 | 1 | |||||
9 | 2008 | 2008 | 2021-2025 | 5 | 2005 | 1 | |||||
10 | 2009 | 2009 | 2026-2030 | 4 | 2006 | 1 | |||||
11 | 2010 | 2010 | GrandTotal | 29 | 2007 | 1 | |||||
12 | 2011 | 2011-2015 | 2008 | 1 | |||||||
13 | 2012 | 2011-2015 | 2009 | 1 | |||||||
14 | 2013 | 2011-2015 | 2010 | 1 | |||||||
15 | 2014 | 2011-2015 | 2011-2015 | 5 | |||||||
16 | 2015 | 2011-2015 | 2016-2020 | 5 | |||||||
17 | 2016 | 2016-2020 | 2021-2025 | 5 | |||||||
18 | 2017 | 2016-2020 | 2026-2030 | 4 | |||||||
19 | 2018 | 2016-2020 | GrandTotal | 29 | |||||||
20 | 2019 | 2016-2020 | |||||||||
21 | 2020 | 2016-2020 | |||||||||
Sheet1 |