search

  1. C

    Copying a dynamic range of cells

    Hi I've currently got a data sheet similar to the one below. The data sheet gains multiple rows each month as each new reporting month is added. The column positioning also changes each month. However the title for each range is the same each month. I want to be able to use VBA to search for...
  2. J

    Getting an exact match in a search

    Hello, new to VBA, so forgive my ignorance. I created a spreadsheet which I am adding data and assigning a number to the data. I have a search setup to make sure the number I am assigning is not already used. It works great except it cannot differentiate between say 75 and 175 or 1075, which...
  3. D

    Search Sheets Help

    I have an idea for a search sheet that i have no idea how to create, and am looking for help. I would like Sheet 1 to just be a search box and you can type in an address, and below it will be a table that will show the results that match your search. The matched search data will be stored on...
  4. HeRoseInThree

    search and display names

    My company hires few people, yet many apply. That being said, I would like to sort through the list of applicants to determine if they have previously applied as to not waste time on someone that we have chosen not to hire. I'd like to search their name in a cell (k12) and have it display a...
  5. A

    Filter search in MS Excel 2007

    Hi everyone, I request you to send the code to enable Filter search in Excel 2007.
  6. B

    Search for multiple text within a cell and return text

    I'm trying to do multiple text searches in a cell and return text if true. If not true then I want the cell to be blank. For example Column A is PaymentNotFound12345 and I want the formula in column B to search for "PaymentNot" and return "PaymentNot". However I need to also search for other...
  7. G

    Unstructured Addresses and Countries

    I have a column with full international addresses with no separators (commas or semicolons). I need to search each cell for a country name and put it in the cell next to it. I've tried to use the search function and it works with one country but when I introduce the full country list, I get a...
  8. I

    Search Multiple tables on multiple worksheets - find next item.

    Morning All, I have a search option on my Userform enabling the user to search via Client or Opportunity name, and use the below code to find the result and populate various text/comboboxes on the search form. This enables the user to check it is the correct record before selecting it...
  9. S

    Search sheet and pull results into a list box based on criteria

    I have a sheet with headers SKU, Name and Stock. I would like to create an userform with 3 textboxes and 3 search buttons below the textboxes to perform a search whatever i enter into each box and place the found results into a listbox for easy viewing. I can write a macro to do a search on...
  10. L

    Sumproduct Isnumber Search is returning same result for different values

    ​Hello - I utilizing a formula that is intended to count the number of visible entries in a table that meets multiple criteria utilizing Sumproduct, Isnumber, and Search. However; I have just realized that in some instances the formula is including results it should not. For example, in the...
  11. L

    Using Excel Filter to Search for text containing a comma & displaying all records that contain one

    I have a list of Email Addresses in an Excel File along with other columns. I Filter the email column to search for mistakes, like double periods (..) which works fine in the filter. But when I search for a comma (,) it's not allowed. Sometimes people type a comma for the period (by accident)...
  12. J

    Search two columns

    I have two workbooks with a company name column in both, I need to search workbook 1 for matching company name and if it's a match I need the name from the contact column in workbook 1 added to workbook 2. I can do this with INDEX/MATCH, but my problem is I have rows under company name that have...
  13. P

    VBA: Following Hyperlink that's linked to Sharepoint?

    I've got a list of Hyperlinks, that are all files on a sharepoint site. When I click on one, it opens Microsoft Edge and at the bottom asks if I want to open the file. When I click "Open", the file then opens in the appropriate desktop app. I'm wondering if there is a way around Microsoft Edge...
  14. S

    Trying to understand how SEARCH work

    So I use the same database, the same cell, same formula. But somehow I get different behavior of formula when I evaluate it. Here I use SEARCH as a single formula {=SEARCH(List,E521)} And I get only first item from the List (table). But here I use SEARCH in combination of formula...
  15. W

    SAP RFC "RFC_READ_TABLE" can search for job names like "*" and "%" of sm37

    English is not good, please forgive me You can search for information by giving the full name with the job name. How to search like sm37, you can use * or % search range Like this StrMaterial = "888_A31-YCH-*" But it doesn't work, so there should be other ways, or the instructions of the...
  16. W

    search function with or function

    how do you incorporate the search & or function into the same formula? i keep getting #Value with my formula. Any help is appreciated. =if(search(or("Best","Good","Average"),A1,1)=1,"Pass","Fail") Thanks.
  17. B

    Nested IF(ISNUMBER(SEARCH Question

    Hello! I am trying to get the following to work, but I think I am missing a ( somewhere along the lines: New Formula =IF(ISNUMBER(SEARCH("Attn Needed",E2)),"Collection...
  18. R

    Search formula with continued text

    <colgroup><col><col></colgroup><tbody> Hi - need help on "Search" formula. Below is the example. When I put the search formula in B1 and B2 it shows the same result as the text continues what I am looking is in B2 it should return error as "Term1" is not there in A2. could you please help how...
  19. J

    Finding most common words in excel

    Hi there, I have several survey question responses. Many of them are paragraphs in single cells. I am wondering if there is a way for excel to look at every word (not just the cell as a whole) and return the most common words. The problem I am running into is that I want to look at each...
  20. H

    Search for text, insert a row above when found, insert text in that new cell, then repeat. How????

    This is probably an easy one for you gurus, but it has me stumped. What I want to do is search for the ! symbol. When it's found, insert a row above it and insert some text. Then go to the next occurrence of the ! symbol and repeat until the end. I created a macro that would do this, BUT, the...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top