Hi guys,
I'm trying to avoid using VBA and was hoping it be possible to just do it using IF THEN Statements
Basically what I'm doing is trying to sort by age groups and age for a summer camp.
I have a spreadsheet were I have names of all kids that got registered for the camp. In this spreadsheet I have 4 columns; Column1=First name, Column2=Last name, Column3=Age, Column4=Gender
What I want to do is put names into a column if they fall under that age category.
So lets say I have a sheet that has Column Ages 1-5 Boys and Column Ages 1-5 Girls. I want to be able to go through my data that has all the names and say if this is a boy and age is 1-5 then copy that name into column Ages 1-5 Boys. and same thing for Girls.
What I have tried doing so far is using the IF statement which technically did what I want it to do but half way.
=IF(AND(Sheet1!$C3>0,Sheet1!$C3<6),Sheet1!$A3&" "&Sheet1!$B3,"") in this formula I dont have an option for where it askes the question of gender.
It if value was false it would return a blank Value but I dont want to have blank values. I want the names to be put one after another. If the statement is false I just want it to move on and copy next true value.
Hope this makes sense. Please help. thank you
Bookmarks