View Single Post
 
Old 02-12-2018, 01:21 AM
LearnerExcel LearnerExcel is offline Windows 7 32bit Office 2003
Advanced Beginner
 
Join Date: Nov 2016
Posts: 82
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default

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.
Reply With Quote