keywords

  1. A

    looking for formula for converting a 2 step process

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

    Excel Macro for moving whole row according to column value

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

    Formula or VBA to see if a cell contains text from large list and if it does, remove it.

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

    VBA - Macro Search, Highlight Red and Bold Predefined Keywords

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

    Populate Column based on matching table

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

    How to Count Data Across Sheets

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

    Dynamic Range Based on Keywords

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

    Formula for looking up keywords and entering text in another column if a certain keyword is found.

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

    Macro for returning URL of the first search result on Google from the keyword list in Excel

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

    Advanced Filter Searching

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

    How to change composed keywords separated by comma into a cell?

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

    Formula to look X cells to right then up to keyword - Step 1

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

    Using VBA to find if any keyword exists in string

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

    help search text string based upon list of keywords

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

    identify specific keywords (plural) in a column of text

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

    Find and remove line based on certain keywords

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

    Searching for Keywords in Excel

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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top