Hey,
I have a sheet with member from a sports club. Now with the new season coming, the categories from the members must be changed. It goes by year of birth. Example:
I have 3 colums: Name, Birthday, Categorie
The values are f.e.
Ali baba - 19/04/1988 - Scholier
The last field is incorrect because his year of birth is 1988 -> the computer should place automaticly "Junior" in the column "category"
Sorry for my bad english, but can anyone help me?
Thankx anyway
I have a sheet with member from a sports club. Now with the new season coming, the categories from the members must be changed. It goes by year of birth. Example:
Code:
1988 (field K2) Junior (field L2)
1989 (field K3) Junior (field L3)
1990 (field K4) Scholier (field L4)
1991 (field K5) Scholier (field L5)
1992 (field K6) Cadet (field L6)
1993 (field K7) Cadet (field L7)
1994 (field K8) Miniem (field L8)
1995 (field K9) Miniem (field L9)
1996 (field K10) Pupil (field L10)
1997 (field K11) Pupil (field L11)
1998 (field K12) Benjamin (field L12)
1999 (field K13) Benjamin (field L13)
2000 (field K14) Benjamin (field L14)
I have 3 colums: Name, Birthday, Categorie
The values are f.e.
Ali baba - 19/04/1988 - Scholier
The last field is incorrect because his year of birth is 1988 -> the computer should place automaticly "Junior" in the column "category"
Sorry for my bad english, but can anyone help me?
Thankx anyway