Hi
I searched for Advanced Filter threads and none have answered my problem
Ive looked up Microsoft Office Assistant and followed the steps but it doesn't seem to be working.
I have a file containing rows of data, one of the columns contains the owners name. Seperatly (on a different sheet) I have a column of names.
I want to use advance filter to go through the main datasheet and pull out the ones that have an owner name that appears in the list of names.
When I tried an AutoFilter it allowed me to enter 2 names and the filter worked.
I tried setting up an Advanced filter but it returns the Column headers (owner name, company name, etc) and all the rows. So no filtering is being done.
So my question is, what exactly goes into the 3 range boxes? Do you include the headings in the List Range and Criteria Range? In Criteria range do I just include the column being checked against (in this case the list of names) or do I need to do something else?
Thanks for any input
I searched for Advanced Filter threads and none have answered my problem
Ive looked up Microsoft Office Assistant and followed the steps but it doesn't seem to be working.
I have a file containing rows of data, one of the columns contains the owners name. Seperatly (on a different sheet) I have a column of names.
I want to use advance filter to go through the main datasheet and pull out the ones that have an owner name that appears in the list of names.
When I tried an AutoFilter it allowed me to enter 2 names and the filter worked.
I tried setting up an Advanced filter but it returns the Column headers (owner name, company name, etc) and all the rows. So no filtering is being done.
So my question is, what exactly goes into the 3 range boxes? Do you include the headings in the List Range and Criteria Range? In Criteria range do I just include the column being checked against (in this case the list of names) or do I need to do something else?
Thanks for any input