• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Searching Data on multiple Criterias

P

prasaddn

Active Member
Hi All,

lets say i have information of records like in attached file, Data tab. The data consists of account name, salesman name, 5 columns of keywords, email sent and received, etc.

What I am trying to achieve is in Search Tab. I would like the user to put any word in the search criteria and it should list all records from Data tab in search tab based on word being searched.

It could be one of those keywords, client name or salesman name.

Second thing, the user need to choose either the combination of search criterias as "and" or "OR" to get the results.

example:
if the user searches for vitamins - it should show 7 records having vitamins in any of the columns.
if the user searches for Vitamins and Fruit - it should show 2 records having both vitamins and fruit.
if the user searches for Vitamins or Fruit - it should show 16 records having both vitamins and fruit.

My approach:
I have created on maskeykey field in the last column in data tab, which is concatenation of all the columns.

Help needed:
1. some tips on how to proceed.
2. I am okay with formulas or VBA based solution.
3. Links related to same problems.

Regards,
Prasad DN
 

Attachments

  • Data and Search.xlsx
    11.4 KB · Views: 5
Q1: Vitamins and Fruit or ' ' or ' ' or ' '
Should there be three possible choices with dropdown and, or, blank ?
Q2: What do You mean with '3. Links related to same problems.' ?
 
You must log in or register to reply here.
Back
Top