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.
|