Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Unique Filter Code / Advanced Filter
I have a database of information. I want to remove all duplicate
entries for each patient. For some reason, the advanced filter - uniques only, still shows duplicate names. I've checked with =A2=B2 and it comes back True. Any suggestions on how to fix or is there VBA code that will give me the same result? Brendon |
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Unique Filter Code / Advanced Filter
Does your table that you are using in the advanced filter only have one
column? If not you need to look at the whole table. If you for instance have Names Numbers Mr X 1 Mr X 2 Mr Y 3 Mr Z 4 and use that table and select unique records only, then all those entries are unique. Is that what you did? If it is you need to use a criteria range Use a 2 cell criteria, assume the names start in A4 with the header so the data starts in A5 and that H1:H2 is the criteria range, leave H1 blank in H2 put =COUNTIF($A$5:A5,A5)=1 select the table, do datafilteradvanced filter, DON'T select unique records, put $H$1:$H$2 in the criteria range and select copy to another location That will give you this list Names Numbers Mr X 1 Mr Y 3 Mr Z 4 -- Regards, Peo Sjoblom "Fester" wrote in message ... I have a database of information. I want to remove all duplicate entries for each patient. For some reason, the advanced filter - uniques only, still shows duplicate names. I've checked with =A2=B2 and it comes back True. Any suggestions on how to fix or is there VBA code that will give me the same result? Brendon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unique records by advanced filter | Excel Discussion (Misc queries) | |||
Advanced Filter - extracting unique records | Excel Worksheet Functions | |||
Concatenate Unique advanced filter results | Excel Discussion (Misc queries) | |||
Error using Advanced Filter Unique Records | Excel Discussion (Misc queries) | |||
Advanced Filter - Unique Values | Excel Programming |