Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
placing people into age groups based on their DOB
I am trying to classify people into age groups in Excel based on their DOB.
U8 1-Jan-2003 to 31-Dec-2006 U10 1-Jan-2001 to 31-Dec-2002 U12 1-Jan-1999 to 31-Dec-2000 U14 1-Jan-1997 to 31-Dec-1998 U16 1-Jan-1995 to 31-Dec-1996 U18 1-Jan-1993 to 31-Dec-1994 U20 1-Jan-1991 to 31-Dec-1992 Senior before 31-Dec-1990 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
placing people into age groups based on their DOB
Create a table of values, column 1 is the start date, column 2 is the
category, in reverse date order (first is 31-Dec-1990, and so on), and just use VLOOKUP with a final parameter of TRUE. -- HTH Bob "JSAUS" wrote in message ... I am trying to classify people into age groups in Excel based on their DOB. U8 1-Jan-2003 to 31-Dec-2006 U10 1-Jan-2001 to 31-Dec-2002 U12 1-Jan-1999 to 31-Dec-2000 U14 1-Jan-1997 to 31-Dec-1998 U16 1-Jan-1995 to 31-Dec-1996 U18 1-Jan-1993 to 31-Dec-1994 U20 1-Jan-1991 to 31-Dec-1992 Senior before 31-Dec-1990 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
placing people into age groups based on their DOB
Try the below formula with DOB in cell A1
=LOOKUP(YEAR(A1),{0,1991,1993,1995,1997,1999,2001, 2003,2007}, {"Senior","U20","U18","U16","U14","U12","U10","U8" ,""}) -- Jacob "JSAUS" wrote: I am trying to classify people into age groups in Excel based on their DOB. U8 1-Jan-2003 to 31-Dec-2006 U10 1-Jan-2001 to 31-Dec-2002 U12 1-Jan-1999 to 31-Dec-2000 U14 1-Jan-1997 to 31-Dec-1998 U16 1-Jan-1995 to 31-Dec-1996 U18 1-Jan-1993 to 31-Dec-1994 U20 1-Jan-1991 to 31-Dec-1992 Senior before 31-Dec-1990 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
placing people into age groups based on their DOB
This works - but I forgot to mention that if filed (say B1) contains either
"Volunteer" or "Non playing member", then this should be placed into the field instead of an age group "Jacob Skaria" wrote: Try the below formula with DOB in cell A1 =LOOKUP(YEAR(A1),{0,1991,1993,1995,1997,1999,2001, 2003,2007}, {"Senior","U20","U18","U16","U14","U12","U10","U8" ,""}) -- Jacob "JSAUS" wrote: I am trying to classify people into age groups in Excel based on their DOB. U8 1-Jan-2003 to 31-Dec-2006 U10 1-Jan-2001 to 31-Dec-2002 U12 1-Jan-1999 to 31-Dec-2000 U14 1-Jan-1997 to 31-Dec-1998 U16 1-Jan-1995 to 31-Dec-1996 U18 1-Jan-1993 to 31-Dec-1994 U20 1-Jan-1991 to 31-Dec-1992 Senior before 31-Dec-1990 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ot - web based discussion groups | Excel Discussion (Misc queries) | |||
Create groups based on measure in pivot | Charts and Charting in Excel | |||
Assigning people to places based on rank and preference | Excel Discussion (Misc queries) | |||
creating groups based upon correlations | Excel Worksheet Functions | |||
divide a large group of people into smaller groups by their vote | Excel Discussion (Misc queries) |