How do I group certain data from a spreadsheet

R

RozRod

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?
 
D

Duke Carey

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
 
Top