keyword

  1. T

    UDF Request Concatenate(C1,D1) Placing D1 After a specific word if its in C1

    Input:C1 Mary went down the and hurt her head D1 hill Desired Output: Mary went down the hill and hurt her head Below is the best what I can describe the logic as: (If C1 contains "keyword") (Separator " ") concatenate [D1] as "[C1...Keyword][Separator][D1] [Rest of C1]" Below is the...
  2. F

    Web scraping

    good day im trying to search data after navigating to the website and then entering input into the search field following is the html code first selecting "Search Cr" from drop dow <!-- Dropdown menu Start --> <div class="bs_LblockDropdown_App1 bs_LblockDropdown_Common" id="Div10">...
  3. M

    HELP! Finding SUM, AVERAGE, MIN, MAX formulas for cells that have numbers and text in them

    Hi, Could you please help me finding excel formulas for the following problem? I have the following cells on the same column (column A, rows 1-5): A 1 00:30 random1 !day random6 2 01:00 random2 !day 3 02:00 random3 !night 4 01:15 random4 !night random7 5 00:15 random5 !day...
  4. D

    VBA: InStr(x,Keyword) where keyword is a variable! My code doesn't work

    Hello, I have 6 keywords that I would like to cycle through with the following code but I can't seem to get it to work. Any ideas? Sub ChangeLinks() Dim wb As Workbook Set wb = Application.ActiveWorkbook Dim Path As String Path = Application.ActiveWorkbook.Path Dim NewName As String Dim...
  5. B

    How do I return text when it finds a keyword?

    Hello All - You were extremely helpful on my post about looking through multiple columns to see if a keyword was in there, but was wondering if you could help on this. The below is the formula you provided on my original post accomplished finding if a certain keyword was in columns H3 - R3...
  6. B

    Check 12 different columns for certain text? - Thank you

    Hello Excel, Looking for some assistance on the following problem: I have a keyword in column "E" that goes down approximately 4,000 rows. Columns A - D have the following rules 1. They contain no text 2. They contain the specific keyword in column "E" 3. It contains the specific keyword...
  7. C

    Macro - Return row of data to sheet2 from keyword on sheet 1

    I have the below code that returns what I want. But it returns it to Column A. How do I get it to return the data starting in Column B? Thank you, Clint Sub EFP() Dim keyword As String: keyword = Sheets("Results").Range("B3").Value Dim countRows1 As Long, countRows2 As Long...
  8. S

    Write several words in a cell conditionned to statements in several other cells

    Hello guys! I am currently doing a qualitative analysis of short comments. I have created a spreadsheet with comments as rows and categories (or 'codes') as columns; so that for the comment "I like ice cream and tea", I will tick the category "food" and "beveridge" ("ice cream" being included in...
  9. S

    Delete Rows

    Greetings, I have been looking through the forums for an example, but i can't find exactly what I am looking for. I am looking for VBA to run through my sheet and remove rows that contain a certain keyword (override) in a certain column (F). The thing that is tripping me up is that the...
  10. V

    VBA to draw data from websites on chrome, filter that data by keywords and make the keyword equal to specific value in adjacent cell

    Hi all I am trying to draw data from a webpage, i need to get that data into excel and make a search (e.g. India, United States, China) run automatically on the data so that when a keyword is found, it is equivalent to a specific value (e.g. Indian Rupee, USD, Chinese Yuan). Help please Im...
  11. K

    Can't detect keyword in cell to display NA

    Hi All, I think my formula is wrong, but not sure where or how to do it to make it show NA at K12. It suppose to show NA when J12 is empty and N12 has the keyword exchange...
  12. M

    Copy cell, if content matches certain keywords in Google Sheets

    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"...
  13. W

    Excel VBA - Text entered in searchbox doesn't cause page to show results (Search without Submit button)

    I am quite new to coding and have the following issue: I want to write a macro, that goes to the website: https://displaypurposes.com/ inserts a keyword and copy the results into my excel sheet. This is how my code looks at the moment: Sub DisplayPurposes()<code style="margin: 0px; padding: 0px...
  14. V

    Comparing strings using InStr() - vba help required

    Hi All, I am using the code below to search for a keyword in a string against a list of keywords located in another tab, if the word exists then the row is copied over to another sheet. The code works, however it has to be run twice to complete successfully. I am using a nested For Each Loop...
  15. M

    How to Compare Whole Words in String between 2 columns

    I have 2 columns of data, one with a product description and the other with Keywords that apply to that product. Currently, the Keyword contains words that are also found in the Product Description. I need to create a new Keyword column that excludes those words. I don't want any whole...
  16. T

    Use of "Continue" keyword giving compile time error

    Hi Friends, I am bit confused as this keyword("continue") exits or not in VBA. Then after googling I found this link https://docs.microsoft.com/en-us/dotnet/visual-basic/language.../continue-statement Here they have mentioned the use of this keyword. But when I tried to implement that it is...
  17. J

    Tricky One: Lookup keyword from multiple sheets > output row

    Hi, Dont know how to go about doing this or if its even possible. Example DataFolder (full of userdata sheets same format) I want to input a name, and macro to search through all the sheets in a set folder and get all the rows of that user from sheet1. Thanks for any help
  18. F

    Search keyword in list with partial keyword found

    Hi everyone :)I have this problem at work with a massive list of keywords that i need to find and match to another list.Creating the right formula will save me like 10 hours of work, so i would be extremely thankful for a solution.I have 2 list of keywordsbut i can only find part of the keyword...
  19. S

    Macro to select multiple contains from another sheet

    Hi, I am stuck here with below query. I have one excel data sheet1 column "E" I have data and in "sheet2" in column A I have some keywords. I want a macro to copy the keyword from sheet2 and search that keyword in sheet1 (contains) and next to the same I need macro to write "exclude". Now I...
  20. W

    Categorize text with keywords

    Hello, I am attempting to use a formula that will search for key words in text fields of cells and return the appropriate category> <colgroup><col><col></colgroup><tbody> =INDEX(CATEGORIES,MATCH(TRUE,ISNUMBER(SEARCH(KEYWORDS,A2)),1)) I am using this formula. But keep getting an #NA...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top