wrightyrx7
12-16-2013, 06:32 AM
Hi all,
Sheet 1
Column A has a list of peoples names.
Column B has a list of ages.
Is it possible for me to have a formula on sheet2 that I can copy down to list all the people of a given age?
Obviously there would be part of the formula for me to edit with the age.
I know how to do this in VBA, but need to do it as a formula.
Any help would be great.
Sheet 1
Column A has a list of peoples names.
Column B has a list of ages.
Is it possible for me to have a formula on sheet2 that I can copy down to list all the people of a given age?
Obviously there would be part of the formula for me to edit with the age.
I know how to do this in VBA, but need to do it as a formula.
Any help would be great.