| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternatives to advance filtering?
Anyones help would be greatly appreciated. I believe that when using the
advance filter function it applies an asterix/wildcard at the end of the word. Can anyone tell me what the VBA coding is to look for a true/exact word - i think it incorporates and = sign immediately before the word? -- Alwyas Trying Eddie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Alternatives to advance filtering?
Enter this as text (preform the cell as text or start with an apostrophe):
'=Ed (to retrieve all the Ed's, but not the Eddie's.) Or use a formula that evaluates to that same text string. ="="&"ED" Eddie Holder wrote: Anyones help would be greatly appreciated. I believe that when using the advance filter function it applies an asterix/wildcard at the end of the word. Can anyone tell me what the VBA coding is to look for a true/exact word - i think it incorporates and = sign immediately before the word? -- Alwyas Trying Eddie -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Alternatives to advance filtering?
That is great Thank you Dave
-- Alwyas Trying Eddie "Dave Peterson" wrote: Enter this as text (preform the cell as text or start with an apostrophe): '=Ed (to retrieve all the Ed's, but not the Eddie's.) Or use a formula that evaluates to that same text string. ="="&"ED" Eddie Holder wrote: Anyones help would be greatly appreciated. I believe that when using the advance filter function it applies an asterix/wildcard at the end of the word. Can anyone tell me what the VBA coding is to look for a true/exact word - i think it incorporates and = sign immediately before the word? -- Alwyas Trying Eddie -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Alternatives to advance filtering?
Another option is to check "transition formula evaluation" in Excel options,
before applying the filter, but make sure to uncheck it off after. ActiveSheet.TransitionExpEval=True Range.AdvancedFilter ... ActiveSheet.TransitionExpEval=False "Eddie Holder" wrote: Anyones help would be greatly appreciated. I believe that when using the advance filter function it applies an asterix/wildcard at the end of the word. Can anyone tell me what the VBA coding is to look for a true/exact word - i think it incorporates and = sign immediately before the word? -- Alwyas Trying Eddie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting data and Advance filtering to get totals on a spreadsheet | Excel Discussion (Misc queries) | |||
| Need advance filtering to grab records that contain certain charac | Excel Discussion (Misc queries) | |||
| What are the alternatives ??? | Excel Discussion (Misc queries) | |||
| advance filtering | Excel Discussion (Misc queries) | |||
| Advance filtering with multiple conditons | Excel Discussion (Misc queries) | |||
Linear Mode
