keyword

Hey everyone, I am tryin to search keywords in a big text but cant figure out how. I have a cell with a big text in it and I want to find keywords in that text, if a keyword is found I would like for it to be displayed. To give a more clear example I made an XL2BB below. I would love for it to...

Hi, I'm trying to automatically categorize a large amount of products by finding keywords in the product descriptions. Using a textjoin, if, count if fucntion works perfectly because if mutiple keywords match, it indexes all of them. But these products come from a range of different suppliers...

Hello all! I'm hoping this is a simple one for you all… fingers crossed! I have a spreadsheet with heaps of tabs and have two macro requirements. 1) If I list 10 tabs in cell A2-A11 of the "Collation" tab, I need a macro that will loop through each of the 10 tabs listed and copy cells A4:C40...

First off, I'm open to a variety of solutions for this situation. I'm currently working on using excel to make a searchable database of documents. I'm hyperlinking the articles, and have some advanced filter settings right now. I'm making a column that contains keywords that relate to the...

Hi all. I need Excel to count lines that include the phrase "test & 10", but not to count other lines that only have the word "test" without the & 10 I'm finding that I get zero results for "test & 10" as the keyword 'test' is filtered out in the 1st argument. The formula I've tried is...

I need some help again :D I need to find from Column A2 below from Data (sheet) and replace from Column A2 below keyword (Sheet) replace format as what found in Keyword sheet A1 is header

Hi, i have a sheet where i need to find the keywords from a list of keywords in each cell into a particular column. What I want to do, though, if look for a long list of keywords simultaneously, and if ANY of those keywords are present, have it return that "keyword". So what I want it to do is...

Hello guys, This is my first post. Please let me know if I should post in a different thread. I want to run a VBA Makro that searches for a keyword in several Word documents and generates a list of document names when the keyword is found. - lets say we have 50 word documents, all in one...

Hello, I'd like to come up with some VBA Code that will look up the following keywords in Columns E and I of my Excel file and delete those rows: Jans (this keyword needs to be searched in Column G only) Resistor % Diode Trans MCKT Micro Conn Relay Inductor Thanks

Does VBA support any kind of "keyword" parameter? By this, I mean parameters of the form keyword=value. Something like this: =MyFun(A1, B2, Keyword4=C3, Keyword2=D4, ...) I am working on a UDF that has half a dozen optional parameters with more to come. Most of them are omitted on most...

hi, i've done hours of ressearch and i can't find what im looking for. I've seen stuff like Vlookup, Index, etc. they all don't work because you need to have the same keyword repeated in your list which i do not have. What i need to do is search for a keyword and write all the results in a...

Hi everyone! I work in medicine and have a data analysis project I'm trying to work on. The basic premise is that I have an excel workbook that's the output of a database search of our radiology records system (submitted a keyword search to radiology system, it output all results to this...

Hi All I need to unzip a file by a keyword of a file since the file name contents some variable numbers and dates which are varied with the date. Therefore I tried to create a code to unzip a file by its keyword. I tried to use a function with a sub but it does not respond me. How do I fix...

Hi Guys, I'm looking for help/suggestions in writing a piece of VBA that will be added a rule on Outlook. What i want it to do is take the attachment off an email that will have a set keyword and copy and paste the data from the attachment to a file that already exists and then autofill a...

Hi All, Have a question as to how I can go about creating a phrase in 1 column based on a keyword in a different column. For example, if a number in the range of 500-750 Appears in column C, I need “do not instruct” in column Obut only on those rows in which the range is >= 500 and <=750. I...

Hello, first time posting...I borrowed a bit of code to create a search box in cell B1. This allows me to search in the Range for a keyword, and it returns matching rows. I would like to know how to expand this, in order to search for two or three keywords. Thank you! Sub...

I have a list of internet search keywords and I want to filter out ones that have state or city in the keyword string. Is there any way to write a formula that references a list of states/cites and if any of state/city keywords appear in a keyword to have the referenced keyword appear in a...

What I want to do is set up a landing page and a keyword search box. The keyword would search through 4 sheets' description columns to return approx matches to the keyword. Below the keyword entry box, I would have 4 headers (to match the four pages) that would have the formula I'm trying to...

I have a timer script from the web that uses the AddressOf MySub as the callback. Apparently it worked for the person who wrote it. However, it fails to compile at least under Excel 2013. Is this keyword and functionality still valid in VBA? In 64bit? I can post the entire timer script if...

Hi, I am trying to copy certain ROWS from my "DATA" sheet to my "Planning" worksheet with a MACRO, and am having some issues with adding more than 1 Keyword to my search. Right now my Key word is "PFP", and the only way I found to search for another keyword is write out the formula below it in...