I have a column A with rows which contains years 2002,...2012... 1999 and column B has genders
Column A Column B
2010 B
2012 G
1999 G
2003 G
2014 B
2014 B
and more last row with year and gender..
I want to know:
Boys 0-12 years old =
Boys 13-18 years old =
Girls 0-12 years old =
Girls 13-18 years old =
Kids older than 18 =
It should consider the date from the pc so I dont need to change the data each year.
Anyone who can assist me?
Bookmarks