|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 16th, 2010, 01:20 PM
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
March 16th, 2010, 01:29 PM
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
March 16th, 2010, 01:33 PM
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
March 17th, 2010, 02:42 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
