Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter Unique Records
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter Unique Records
Hi, Dee,
auto filter, select the arrow on the investigator column, set John Smith and done, if you do not see the rows where John appears on this column and on another one, click on the arrow on the other column costum to different from John Smith HTH Regards from Brazil Marcelo "Dee" escreveu: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unique filter results in some non-unique records. | Excel Discussion (Misc queries) | |||
Error using Advanced Filter Unique Records | Excel Discussion (Misc queries) | |||
automatically filter for unique records... or other suggestions | Excel Worksheet Functions | |||
Counting unique records with additional criteria | Excel Worksheet Functions | |||
Inconsistent Results: Advanced Filter Unique Records Only | Excel Discussion (Misc queries) |