1. D

    Extract text between MULTIPLE parentheses in one cell

    Hello, I would like to extract text between MULTIPLE parentheses in one cell (without using VBA). The blue text in the picture below is what I'd like to achieve automatically. When there is just one set of parentheses, it's easy. For B1 I could use...
  2. J

    Search 3 Columns for 1 Word

    Hi, I want to search more than one column for a single string, I can do it for one column but having a problem over 3 columns without having to add extra columns and do it individually then do an If statement for the final column. This works for a single column...
  3. F

    Using Match to return the highest value for a coincidence

    Hi, this is my first post here! The reason i suscribed here is because I was looking forward to improve a formula to match my needs. Let me tell you about it a little: I have this data set: When you put an X on column E it sums always the value that is displayed on there, no matter what...
  4. R

    Keyword Search and Select Macro?

    First off, I'm open to a variety of solutions for this situation. I'm currently working on using excel to make a searchable database of documents. I'm hyperlinking the articles, and have some advanced filter settings right now. I'm making a column that contains keywords that relate to the...
  5. N

    Pull data from different tab, same row, different column

    Hello, I have a monthly labor report for which I would like to pull the estimated costs from a secondtab and sum it with the data in the first tab based on searching a column in tab 2 for the text that matches the cell a column in the first tab. So it looks something like setup: Tab 1...
  6. F

    SUMPRODUCT IF value equals

    Hello, could you please kindly help me with the below, to make it so that it'd only consider values for the calculation if the corresponding value in column 'A' = "XX", and instead of specifying the range, sums up all the matched values in a given column? Please also note that values start in...
  7. D

    IF function with ISNumber(Search()) and Vlookup

    Hi! I am trying to write a function that would use two vlookups, where in the first vlookup there are also IsNumber(Search()) supporting it. What I have written looks like this - IF(ISNUMBER(SEARCH("part of text", d3)),VLOOKUP(D3, 'tab x'!A:B,2,false),VLOOKUP(D3, 'tab x'!A:C,3,FALSE)). As you...
  8. P

    Search in Range created from a condition or first searching

    Good morning, everyone, the present problem: It consists of 2 parts: First part of the problem. First we have two sheets: Sheet1 and SP2 In Sheet1 we have key elements column B which contains codes from row 5 downwards and then we have row 3 to the right starting from column L which contains...
  9. R

    64 nesting limit

    hello, i would like to ask a question, regarding a problem i've faced recently. I want to take out a specific information from a text, which varies, for example: asdjhbasdas1234BGasdhasd - i want to take out and display just the 1234BG iaiopsunlkas1234BGpiouqws- i want to take out and display...
  10. T

    VBA - Search workbook for list in sheet1, and delete all rows containing those values

    I found similar requests here, but nothing that I could make work for what I needed. I have a list of over 200 inactive part numbers (and more may need to be added) in Sheet1 column A. In all other sheets in the workbook I want to search through column C, starting at row 8, and delete the row...
  11. T

    Need VBA to find terms in column A and move the data in the cell to another column

    Hi all, I'm trying to self teach myself how to do this, and I cannot figure this out. Attached is an example of what I want to learn. If I have column A as my raw data, I want to have a macro that will search, for example, "apple" and move the data in the cell over to column B, search A for...
  12. G

    VBA Loop for copy and paste with search

    Hi There, Thank you in advance for taking the time to read this. I've tried to search for the answer but to no avail so I'm hoping some very kind person will be able to help put me out of my misery. I'm trying to search for a specific term within a column of a worksheet, if that is found...
  13. M

    Only run specific macro on sheet with cell equals particular year, or range of years

    I have the below macro that searches an entire workbook for a particular string and returns that value from a cell a few cells down. I now need it to search only worksheets that contain particular year, or range of years. So that it is out the way and kind of hidden im going to put the year in...
  14. M

    Combining IF, COUNTIF, ISNUMBER, SEARCH in a formula

    Hi Hoping someone might be able to point me towards a solution that has me stumped combining a number of search functions. I have a roster with three general information columns: Position title, is the position active, company the position reports to. There is a separate summary sheet that is...
  15. W

    data search vba

    I have a large Q&A spreadsheet with rows that include question, answer, category, sub category, and date updated. I am looking for someone to create a form in which I can search with the option of filtering by category. I am thinking a place to insert the phrase or question (and be able to...
  16. H

    VBA Find, Copy, paste

    Good Morning Friends, I have an employee training spread sheet that lists out the employee and all the areas that they are trained in. However, the row is super long because their are a lot of areas across different departments that they could be trained in. My row currently goes all the way to...
  17. M

    Find / Search Duplicate Values in slash or (-) character Data in one cell

    I want to find a value among the multiple values in one cell, I hope the given picture will help understanding the actual issue. Hope to get some solution from some Mr. Excel :) P.S :- Please i need some formula instead of VB Code
  18. M

    Count Number of digits 0-9 to the left of a Specific Character in a Cell

    I used a formula to parse a field that typically contains text like the following: 1F5H or 13F1H The following formula works just fine when the number of digits to the left of a given character is static, like 1 numerical digit. However, I'm not sure how to determine how many numerical digits...
  19. D

    Search two columns using one criteria return third column

    The results in column "N" are either in column "T" or "U" I need to be able to find the matching number in Column "T" or "U" and return what is in column "V" into column "K". If no results are found it needs to say "check lookup table" Index, Match will only look at one column, not sure what...

Some videos you may like

This Week's Hot Topics