I have a spreadsheet with names and addresses. I have site # ,site name,
investigator, contact person etc. the investigator's name is listed many
times as there may be 3, 4 or more people at each site. I want.or example,
there may be an investigator named John Smith his name will appear in the
investigator column and also in the contact person column because he is the
main contact person. Then there may be 2-4 other contact people listed so in
the investigator column John Smith appears more than once.

Can I filter this sheet so that I only the rows where the contact person is
the investigator?

Thanks in advance for your help.

Regards,

Dee