looking all matching values

[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

 

[Ken Wright]

Take a look at Pivot tables. Can be created in no more than 30 seconds and will
do all you want and more:-

http://peltiertech.com/Excel/Pivots/pivotstart.htm