Hi,

I don't know as though this is possible but I thought I would give it a go.

Column A Cols B:F Column G
Teacher Student

Column A will have the same Teacher listed for multiple students in Column G.

Is it possible to filter to all of the Teachers that have a specific student
but showing all students in the class as well?

For example filtering to Henry:

Col A Cols B:F Col G
Nancy Jones Whatever George
Nancy Jones Henry
Nancy Jones Mary
Nancy Jones Susan
John Henry Albert
John Henry Lewis
John Henry Mary
John Henry Henry
etc.

The way I think of doing it would be time consuming and would involve
uploading the data to another sheet. For example, search for the matching
student. Once a match is found, load the teacher into an array. Then copy
all rows for all of those teachers onto a sheet.

Is there a way of just filtering the existing sheet? I need to be able to
edit data in this filter so another sheet won't do it.

--
Thanks for your help.
Karen53