|
|
#7
02-12-2018, 01:21 AM
|
|||
|
|||
Working fine now. But how can I modify formula to search with field "Code" & "Tax%" instead of "Region" & "Tax%"? The problem here is, if the field Code has 1 Character or 5 Characters it should consider it as one criteria and if it has 8 characters then it should consider it as second criteria and accordingly filter the data.
It means, if I select "1" or "5" in E3 it should show all the rows related to 1 and 5 characters in field Code. If I enter "8" in E3 then it should show rows only related to 8 characters in field Code. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Sum based on multiple criteria (one of the criteria is not unique) until a threshold is reached.
|
phillipsdp | Excel | 1 | 11-09-2016 12:53 AM |
|
Filter Mail Merge based on a list of filter criteria
|
AusSteelMan | Mail Merge | 2 | 05-09-2016 03:35 PM |
| Auto fill drops down using VBA code based on selection | AgilityJS | Word VBA | 5 | 11-03-2015 07:50 PM |
| Forgotten Sort and Filter Criteria | rbdmg | Mail Merge | 0 | 10-31-2011 09:14 PM |
| Modify vba code to print based on name in the InputBox | OTPM | Project | 0 | 05-25-2011 02:03 AM |
Windows 7 32bit 
Office 2003
Threaded Mode