Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advance filter search does not filter an exact match
I'm using a advanced filter to of course filter a list. My problem is that if I filter for something like "dogs 1" my results are "dogs 1" but also anything the has "dogs 1" in it, such as "dogs 11", "dogs 10", I just want "dogs 1" only though. This is a probably a simple solution. Any help would be great, thanks Here is a sample of the code I'm using! ' set the range of the original source data datarng = "a101:g" & Format(lastdatarow, "#") Range(datarng).AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=Range(CritRng), CopyToRange:=Range("i101:o3000"), unique:=False End If -- cfiiland ------------------------------------------------------------------------ cfiiland's Profile: http://www.excelforum.com/member.php...o&userid=24174 View this thread: http://www.excelforum.com/showthread...hreadid=377978 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advance filter search does not filter an exact match
In the criteria area, enter: ="=dogs 1"
or ="="&K2 where K2 contains: dogs 1 cfiiland wrote: I'm using a advanced filter to of course filter a list. My problem is that if I filter for something like "dogs 1" my results are "dogs 1" but also anything the has "dogs 1" in it, such as "dogs 11", "dogs 10", I just want "dogs 1" only though. This is a probably a simple solution. Any help would be great, thanks Here is a sample of the code I'm using! ' set the range of the original source data datarng = "a101:g" & Format(lastdatarow, "#") Range(datarng).AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=Range(CritRng), CopyToRange:=Range("i101:o3000"), unique:=False End If -- 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 | |||
My Advance Filter Doesn't Filter | Excel Discussion (Misc queries) | |||
Advance Filter | Excel Discussion (Misc queries) | |||
Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
Advance Filter | Excel Discussion (Misc queries) | |||
advance filter | Excel Discussion (Misc queries) |