How do I group certain data from a spreadsheet

I have an excell spreadsheet creating a log of investigations assigned to
certain investigators. How can I print out a list for each investigator with
all their respectively assigned cases?

Data | Filter | AutoFilter

This will create little drop downs next to each column header. Select each
Investigator from the drop down and Excel will show you only the assigned
cases


"RozRod" wrote:

> I have an excell spreadsheet creating a log of investigations assigned to
> certain investigators. How can I print out a list for each investigator with
> all their respectively assigned cases?