keywords

Hi Folks, So I have an macro code which searches through "column C" for specific keywords and moves it to "Sheet2" the whole row if it matches the keyword. Example: I made the code to move the whole row if there is a keywords such as "town, county, city, state, etc" I did this because I have...

Excel 2011 32 bit <tbody>#F0E0E0[/URL] "] B C D 2 #FFFFFF[/URL] , align: center"]Program #FFFFFF[/URL] , align: center"]Score Grade 3 #FFFFFF[/URL] , align: center"]RM1 #FFFFFF[/URL] , align: center"]3 4 #FFFFFF[/URL] , align: center"]CRA #FFFFFF[/URL] , align: center"]5 5...

Simple question, that I cannot seem too find. Can anyone help me? I would like a formula that searches a cell with a sentence for specific keywords. 10 max. If the keyword is found, then it would put the keyword in the cell. So the cell to be searched would be G6 Keywords would be Theft...

ok so im looking for help on create a formula on the following setup i currently have keywords that are hypen seperated and then there is a space and then the next keyword begins - example below and lets say i place all of these keywords on cell a2 big-car rainy-day giant-woods big-car...

Hi,I am very new to macros and in need of solution please. So I have over 140,000 rows of data in which column "C" has specific keyword(s). I would like to create a macro in which find if it does contain these keywords it would copy it to another spreadsheet. Example: Column C might say...

First time posting so sorry if I make a mistake. I'm trying to go through a list of keywords I have built over the last few months. The list is of 46,849 keywords (column A). I want to check each of the keywords (really keyword phrases) to see if it contains any of the text from a different...

I am looking for a macro (VBA) in Excel 2016 that when applied will search for the predefined keywords in Workbook "Keywords" Column A against Workbook "Voice" Column K to find the predefined keywords in Workbook "Keywords" Column A and those that match will be bold and red color. Sorry guys I...

Hi all, I need some help. I have 2 workbooks, one (results.xlsm) with SKUs in Column A, and I would like keywords I have for them put into Column B. The 2nd workbook (keywords.xls) has some SKUs in Column A, and corresponding keywords in Column B. I would like to use some VBA to match SKUs...

Working on a project, and I need to count how many times different keywords are entered across sheets. I know I could just Click on each sheet and select each individual title, but that isn't efficient because I have to deal with over 100 different data points over a years worth of data. Is...

Can someone give me a hand with this? I have several charts of different types that reference data on a separate tab. The tab where the data resides is similar to this: <tbody> Year Quarter Region Period Opened Closed Pending Pending 30 2013 Q1 Africa/ Eurasia Q1 '13 2013...

Hi guys! I need a formula or a script which will check a if a cell contains keywords from a list in another sheet. If a keyword is found, it will populate the cell next to it with the "category" set for that keyword. So I have a sheet which is called "Keywords" which contains the keywords to...

Hi, So basically I have an Excel sheet which has keywords that need to be entered in Google search. I need the URL of the first page of the search result that appears after that keyword is entered. IS there a macro for the same? I am a beginner so a bit of detailed explanation would help

Hi all, I have been a long time lurker and have had great benefit from old threads around these parts. So thanks :) However, I have come up with a problem I wasn't able to google myself out of... Background: In my company we have an excel spread sheet of procedure titles which link to a PDF of...

Hi folks, nice to meet you all. Lets suppose I have the cell A1 with 100 words or more separated by comma, but the words can be composed word or double words such as "jump up", "Old age","sunny day", or more "holding a face", but I want to find these composed words or double/triple+ words...

Hello all, (Excel 2007 user) I have a spread sheet that has data dumped into one column. I need to assign each row of each page the corresponding Fund and Account number. There are keywords that can be used to search and capture. Each page has a keyword, lets say TopOfPage. The Fund number...

In Excel I'm trying to find if any keyword from a list of keywords exists in a string from within an array. I'm aware of the instr function, but does this work for searching a string from an array of keywords? I'm not sure how many keywords I am likely to require, so ideally wanted a solution...

Hi I need a formula that will use a column list of words as "find text," and the formula will tell me if any instance of any keyword in that list occurs anywhere in a single cell text string. Any word only needs to occur, it doesn't matter how many or which or where.<?xml:namespace prefix = o ns...

So i'm try to automate a process that I currently do using filters. Here is the problem: I have a list of text in a column (usually 700 or so entries). I need to remove any entries that contain 1 of 42 keywords. So I need a fast way to search each cell for each one of the 42 key words and...

Hello, I've been searching here for while now and I'm able to find solution to my dilemma, I hope someone can help me. As you will see in attached sample file (before and after) I need to remove whole line and shift cell up if one of the three keywords is matched. ie. Column C contains SBII...

Hi Guys, Do anybody know how you can do IF Functions to search for keywords within a cell? e.g. If in cell A1 there is "A journalist for the Daily Telegraph blogging around Sport and New Media" but I want to search for the keyword "Journalist" is that a formula I can use so that a "Y" (or...