Sort out age classes

**sealpino** · 01-15-2017, 05:39 AM

I have a list in rows persons birth year.
1943
1950
2016
2005
etc
Let us say 100 persons $A$3:$A$100 in a index.

Now..
I want to select persons to a list that presents the number of each group
based on PC date so I dont need to change it next year from 2017 to 2018.
0-12
13-18
19-25
26-35
36-45
46-55
56-65
65 +

**AliGW** · 01-15-2017, 05:44 AM

In B3 copied down:

=LOOKUP(YEAR(TODAY())-A3,{0,13,19,26,36,46,56,65},{"0-12","13-18","19-25","26-35","36-45","46-55","56-65","65+"})

**sealpino** · 01-15-2017, 06:16 AM

Indeed works fine, thanks
Iwould like to have the numbers of each ageclass to
a list

0-12 34
13-18 49
etc

**AliGW** · 01-15-2017, 06:22 AM

This then:
Excel 2016 (Windows) 32 bit

	A	B
3	1943	65 +
4	1950	65 +
5	2016	0-12
6	2005	0-12
7	0-12	2
8	13-18	0
9	19-25	0
10	26-35	0
11	36-45	0
12	46-55	0
13	56-65	0
14	65 +	2

Sheet: Sheet3

Excel 2016 (Windows) 32 bit

	B
3	=LOOKUP(YEAR(TODAY())-A3,{0,13,19,26,36,46,56,65},{"0-12","13-18","19-25","26-35","36-45","46-55","56-65","65 +"})

Sheet: Sheet3

Excel 2016 (Windows) 32 bit

	B
7	=COUNTIF($B$3:$B$6,A7)

Sheet: Sheet3

**sealpino** · 01-15-2017, 08:13 AM

I really appreciate it
THANKS REAL GOOD ONE

**AliGW** · 01-15-2017, 10:07 AM

You're welcome!

**sealpino** · 02-06-2017, 09:59 AM

HI Can you help me or give me a tip how to proceed?

SEALPINO

**AliGW** · 02-06-2017, 10:01 AM

You will need to mark the thread as not solved if you are asking for more help on the same query. If this is a new query, then you should start a new thread.