keywords

Hi, I have the following table and my goal is to have to restrict the number of keywords per key to 3. For every key containing more than 3 keywords, I want to delete every keyword after the third one...

Hi all, I've scoured the internet for a solution and have tried coming up with a solution myself, but I'm just not proficient enough with VBA to be able to do it (and all of the solutions that I could find online involved a popup input box to manually enter keywords each time). I'm trying to...

Hello, My worksheet has a couple hundred columns and 20k rows. My task is to search for specific keywords in the text within each cell within each row and then write in "yes" or "no" if there is a match in the first column of each row. For example: searching for "dog", "cat", or "horse' in...

Hi Friends, Trying to extract 2 or 3 keywords from cell content through excel vba. Sheet1 ColumnA has rows with content sample file attached. I need vba to search for keywords from sheet2 ColumnA in Sheet1 and extract 2 or 3 or 4 keywords from each row content into sheet3.(Popup box would be...

Hello everyone! I have something I am working on but its driving me a little bats at the moment and I am hoping someone can help. I have a spreadsheet with two columns. Each column has a list of keywords in it. I am trying to compare column 2 against column 1 and place the unique keywords into...

Hello, I have a table with a list of Keywords. I also have a list of Item Descriptions. I am trying to figure out how to count the number of times any of the keywords from the list are mentioned in each item description. For random example: <tbody> A B C D E F G H I J K L M N...

Hi everyone, We create a lot of letters for clients and often find ourselves writing out much the same thing from scratch. I'm looking for a way to paste the text from the letters I write into a database spreadsheet, let's say column A, and characterise them with, say, up to 10 relevant...

The question is in the title, but I've attached a screenshot\edit to sort of get at what I'm trying to do. Let me know if you need any clarification on what I'm trying to accomplish!

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

I have a spreadsheet with 200k+ books/descriptions/etc, and I'm looking for a way to search in each full row (A-x) for keywords (sheet2, column a, not case-sensitive) within the text, and when it finds those keywords, it assigns a unique category ID (sheet2 column b) to each row for each match...

Hi all, I'm trying to write a macro that will filter a database to show rows that only contain certain keywords. I used the macro recorder to recorded a custom filter but have been unable to adapt it for more keywords. Below is the recorded code. Any ideas on how I can get it to filter more...

Hi all, Im starting to build a database workbook for our machine shop that has items we order from different vendors/type of product/cost of product/item number ETC.. This will end up having many entries in it. In very simple terms i want to search thru this list with a "Search box" that will...

I have 2 files. FileA contains the item names. FileB contains a list of keywords. I need a formula that I can use on FileA on the second column that will scan all the keywords listed in FileB and put "1" if it matches and 0 if it doesn't match. I really need help on this. I need it for work...

For example the 2 cells below - Is there a formula that can be used to create a likeness %, Row 1 I would say is a match as they contain keywords, row 2 is not a match as there is no similarity I am open to all recommendations <tbody> BECKER MATT MATTHEW BECKER CONSTRUCTION, LLC </tbody>...

I was able to obtain TRUE or FALSE from multiple keywords using: =OR(ISNUMBER(SEARCH(H$5:H$12,D5))) but how can I return the # of hits? Thanks for your assistance!

I have a range of Keywords (named range Devices) its a somewhat large list 586 lines (it will grow over time). I have on another worksheet a large amount of data will grow to about 100,000+ lines by end of year. I want to search to see if cell A2 in this worksheet contains one of the keywords...

I need help with writing a macro that will take a list of keyword criteria and group referrals into groups, this group name should be appended at the end of the data table. The macro should be customizable, to easily add keywords for a referral group and to add additional referral groups. Step...

I need to copy the value of a cell if the contents contain a keyword from a list in a Sheet I have. You can see an example and make a copy here https://docs.google.com/spreadsheets/d/1Fmn6UtJ8QbRGsGYVgVcUpfg_kmCVk4MLGhNDBVtAxJk/edit?usp=sharing So if the news story listed in "RSS News Feed"...

I'm trying to determine a unique number of occurences for particular keywords in a string as follows: <colgroup><col></colgroup><tbody> sport=formula-one&utm_source=INTERNAL&utm_medium=LINK&utm_content=MOTORSPORT-EDITORIAL-LINK&utm_campaign=ACQUISITION </tbody> I want to count the cells that...

I'm creating a quiz sheet in excel where the user inputs their answer into a cell. (i.e Cell F5) The idea is that if they enter their answer into the answer cell the cell in the next column of that row will show a 'Tick' (uppercase P in windings font) if the answer is corect. At all other...