Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Advanced Filter Not Working
I have a list of 408 people who need review for an award. However, of the
408 I have already entered an award for 193 people. I have an Excel spreadheet which lists in column A the larger list and in column B the people who already have the award. I am trying to filter the unique records from column A by comparing column B. However, I do not seem to be able to get the results I need; in fact I am getting no results. Can anyone help? I was able to do this very function before with little difficulty but seem to have a problem now. Sorry if this is a bit vague. I can provide more information if needed. Thanks. |
#2
|
|||
|
|||
Cells A1 and B1 should contain column headings, e.g. "Name"
Leave cell D1 blank In cell D2, enter the formula: =COUNTIF($B$2:$B$194,A2)=0 Select cell G1 Choose DataFilterAdvanced Filter Choose 'Copy to another location' For the list range, select column A For the criteria range, select cells D1:D2 For the Copy to range, select cell G1 Check the box for 'unique records only' Click OK Cthulhu wrote: I have a list of 408 people who need review for an award. However, of the 408 I have already entered an award for 193 people. I have an Excel spreadheet which lists in column A the larger list and in column B the people who already have the award. I am trying to filter the unique records from column A by comparing column B. However, I do not seem to be able to get the results I need; in fact I am getting no results. Can anyone help? I was able to do this very function before with little difficulty but seem to have a problem now. Sorry if this is a bit vague. I can provide more information if needed. Thanks. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Thanks. :)
"Debra Dalgleish" wrote: Cells A1 and B1 should contain column headings, e.g. "Name" Leave cell D1 blank In cell D2, enter the formula: =COUNTIF($B$2:$B$194,A2)=0 Select cell G1 Choose DataFilterAdvanced Filter Choose 'Copy to another location' For the list range, select column A For the criteria range, select cells D1:D2 For the Copy to range, select cell G1 Check the box for 'unique records only' Click OK Cthulhu wrote: I have a list of 408 people who need review for an award. However, of the 408 I have already entered an award for 193 people. I have an Excel spreadheet which lists in column A the larger list and in column B the people who already have the award. I am trying to filter the unique records from column A by comparing column B. However, I do not seem to be able to get the results I need; in fact I am getting no results. Can anyone help? I was able to do this very function before with little difficulty but seem to have a problem now. Sorry if this is a bit vague. I can provide more information if needed. Thanks. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced filter question | Excel Discussion (Misc queries) | |||
Can Excel advanced filter be used in "and NOT" mode | Excel Worksheet Functions | |||
Advanced Filter using Date represented as text | Excel Worksheet Functions | |||
Advanced Filter: No Filter | Excel Discussion (Misc queries) | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |