This is a solution from NFLSALES , working as intended
I want a small modifacation into the first formula that does the main work
I want it to handle lets say if I type FUSION INDIGO or 30 X 44 30 X 66 ,
currently it can handle only ONE keyword
The likely answer for FUSION INDIGO will look as follows for above 100 on the orange box
Please Login or Register to view this content.
Last edited by makinmomb; 01-08-2015 at 11:39 AM.
Will it be an or combination somewhere , not sure , these admirable formulas I don't look into ,
I am smiles as they do the work as intended and so magically
Last edited by makinmomb; 01-08-2015 at 01:38 PM.
Formula version , maybe easier by macro , not sure
Here is my way..
Using Advfill with a button is all what you need.
Ranges are flexible enough so you can add more data and search keywords.Please Login or Register to view this content.
Check the attached file:-
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
Vikas , changing the search box to boxes was clever indeed
Wow
Vikas check under my introduction forum , I am impressed with your flexible thingi
I asked for two searches and you brought a surprise of 3 and unlimited
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks