search and match string

I have been stuck on this all night and am looking for some suggestions. I essentially need to be able to find a character to the left of a string somewhere in the middle of a large text string so I can return a number value. The data is imported from an external database so I cannot change the...

Hi all, I am new to the forum. I am writing a sheet (link sheet) that includes a number of Hyperlinks (6-700) and I am including tags against each hyperlink; some of the hyperlinks will have more than one tag. I want to create one hyperlink on another sheet (master sheet) in the same workbook...

Imagine A1:A300000 contains a long list of words, like this: <tbody> Column A 1 Applesauce22 2 Bananas 3 Antiapple 4 Applesandpears </tbody> And I have a list of words I'd like to find within the above list, like this: <tbody> Column B 1 apple 2 pear </tbody> The list in...

Hi all I have butchered the below code to run a simple search for a name in a single column and present a message box to confirm the result and highlight. The code although not pretty, works perfectly, so I would like to use the same code on another sheet. The other sheet is roughly the same...

Hi All, this is my first post. I am using Excel 2010 and I enter a string into cell A1. I then want to search this cell from a list of values looking for a match and replace that with nothing "". ie: I enter w480-krusty-01 into Cell A1. I then want to search cell A1 from a list of values (w240-...

Hi, I've multiple entries in column A, which are Text/Number/Character strings and i've created unique set and placed in a row to search the same text in the Column A and return the value at the end of the string. I know it is difficult to explain, here is what is appear like Column A Customer...

I am looking to setup a filter within Excel that will show me all the rows within one worksheet that contain full words from another worksheet. For example: This is in Worksheet A: <tbody> Word List A </tbody> <tbody> email software free email client free email programs free email...

Hi, I have a set of data which I'm looking to filter by the value in one of the columns. That specific column contains ID numbers; there are hundreds of unique ID numbers each with hundreds of entries. I want to extract a table which only represents (for example) 100 of the 500 ID numbers. I...

Hi! So I have been pulling my hair our trying to figure out how to build a VBA for a process that is so time consuming and repetitive and deadly. background: I have hundreds of records of customer info and I am trying to categorize the job titles so that I can conduct some analysis with a...

I have a table that includes a column full of long text comments. On another sheet, I've started a chart of keywords and outputs that I'd like to use to categorize these comments in a new column next to it. For example, if the comment contains the phrase "itemized receipt", I'd like the output...

Hello everyone. I am new to this, please bear with me. I hope I am phrasing my question well. Thanks for your help in advance! I have a spreadsheet with hundreds of URLs, and buried somewhere in that URL is a product code. Convention is not the strong suit here, so the code can be anywhere in...

Hello everyone. I am new to this, please bear with me. I hope I am phrasing my question well. Thanks for your help in advance! I have a spreadsheet with hundreds of URLs, and buried somewhere in that URL is a product code. Convention is not the strong suit here, so the code can be anywhere in...

Hello to everybody! In an excel file with more than 40.000 rows (this might variate) and 50 columns, the code checks for specific strings in a specific area: going from the second row it checks from column C up to column G (or at least I think so), up to the last row (which is unknown because...

I have multiple sheets total =24 i have a new sheet no 25 in which A1:A2000 contains text need to search the text in A1 in sheet1 to sheet 24 in all the 24 sheets the Text will be in the column C only also it need to return the value in F column of the respective text row found in column C...

Hello Everybody, I need helping figuring out how to create a macro for this project. I have about 60k phone numbers in Sheet 1 in Column A in the following format (938) 123-3456 .I need to take the number listed in row 1 on sheet 1 and check it with Columns D-H on Sheet 2 to see if it finds...

I am trying to step down row by row through a range and compare the current row against all the other rows in a range before and after the current row. If a possible duplicate is found where 8 of 9 columns in the row are a duplicate of other rows I want to highlight the rows for investigation. I...

Hi, I am trying to get excel to work like a webapp(eg: google search) where we can have smart search. Problem Statement : I have a list of things in Sheet 1 (Eg: over 100 unique entries in a column, sheet 1 is like a database), which the user is currently using via a drop-down (scroll down and...

HI, I am trying to create a formula that will grab all matching names i.e. "Existing" from a "Customer_List" (large table of customer information with multiple headings) and populate several related cells that Match the "Existing" search (ex. Name, Sales, Role, etc) . I am not proficient at VBA...

I have one sheet (Active) that has a table (tblActive) on it and another that I want to use as a dashboard of sorts. On the Dashboard sheet I have a range named "Provider" that has list data validation setup . I'd like a user to be able to select a name from the Provider list and below that...

I am looking to search for a string within a certain column only and activate that cell. If I have the table below, I want to use an input box to acquire a string from the user and search only column B and activate the cell. If the user enters a string that is not found in column B I'd like a...