use helper columns that establish a common value for the lines of a single
entry and also support use of the autofilter to filter on what you want.
Since I don't know how you filter, I can't suggest a specific solution.

--
Regards,
Tom Ogilvy

Doug Broad wrote in message
...
In a spreadsheet that contains data for classes, some classes
have 2-3 rows of information, each row showing additional
meeting times.

Typical field names are
Dept, No, Sect, Course Title, Credit, Contact, Days, Times, Room,
Instructor

Addtional rows for classes contain only information in Course Title, Days,
Times, Room,
and Instructor
columns.

There are blank rows between classes.

Autofilter shows only the first row of each class. Does anyone have any
ideas how to
show something like autofiltered data but allow the additional rows for
each class to show
up
temporarily.

Thanks for your help.