W
Wes
I have a list of students who's homeroom is listed in one
column. In a seperate area I want to return a list of all
the students in a certain class (one per line). Is there
a simple array formula or something that could do this.
I know that Hlookup can easily find one student, but how
could I find all the students. (I've never used an array
formula, but from browsing through the help menu it
appears that may be my answer.?)
Wes
column. In a seperate area I want to return a list of all
the students in a certain class (one per line). Is there
a simple array formula or something that could do this.
I know that Hlookup can easily find one student, but how
could I find all the students. (I've never used an array
formula, but from browsing through the help menu it
appears that may be my answer.?)
Wes