search

ABCD1Copied EntryExpected Result2Dog*Brown,White,Black,Dragon*Golden,Green,Red,Black,Panda*Red,Black,GreenDog*Brown,White,BlackDragon*Golden,Green,Red,BlackPanda*Red,Black,Green As shown above I would like to parse the cell value for every "*" entry to arrive at the expected result, below is my...

Dear all. I have a data sheet which contains three data columns: Part code, Description and Bin# I need to make two searches within the "DESCRIPTION" column data (Shown by arrows in the image below) and find the PART No. and Bin# as the result. The problem is, both searches shall be done...

Hi, I'm almost certain I'm using the wrong search function. Apologies, my work computer doesn't permit me to install XL2BB. I have one list which has classes and their status in the program. The possible statuses are: Active Confirmed Pending Exploratory There are multiple classes per school...

Hi all! I am trying to find a simple way to search for multiple items at the same time in one excel sheet, and then, hopefully, create a new sheet with all the correct matches. Ideally, I would cross-reference the data between two sheets, and only the matches would appear. I am not an excel...

I have a set of data that consists of one column of dates and another column of values that corresponds to the date next to it. I would like to have a formula that you can search for the lowest date based on the month and year. So if I have February and 2020 as the criteria, and the data is...

Hi! I have a table with the Names of 4 people stated in row 9 column J to M, and the dates of everyday of the month in column I row 11 to 41. There are data ( values) filled in the table. I have a userform with the combobox that is able to select the name (cboName) and another textbox to enter...

Hey guys, I need help with my formula: =FILTER(TDB,(ISNUMBER(SEARCH(F8,TDB[Fund Manager])))+(ISNUMBER(SEARCH(F8,TDB[Description])))+(ISNUMBER(SEARCH(F8,TDB[Tags]))) *(ISNUMBER(SEARCH(F19,TDB[Verticals]))),"Not Found") When I added the part in bold, the formula ignores it. What I try to...

I want to mach 2 columns A is the unique list of name's static B is unformatted console list In C want Names that matches,and very close and higher/approximate possibile name to get captured In D column is any way to put an remark 100%,90%,80%,.....no match...

This is honestly causeing me a headache! I know just enough to maybe toy with a solution but not enough to fix it. So here's the setup: I have 2 columns that are going to fill up via userform entry which log the date a call was placed and the time and duration of the call (in the same column...

Need to extract the values between the hyphen in Column "Values". No VBA please. Trying to use the search function built in. Not sure how to how to deal with the spaces. Values Car Builder Name Location Green Car - Ford - Aisha - Toronto - London Green Car Ford Aisha London Red SUV -...

Hi everyone, its my first time using VBA and any sort of coding in general so I have been cracking my head for weeks trying to do this UserForm . I'm wondering if there is anyone here that could help me with it? Any help is appreciated, Thank you in advance!! I have 2 main issues that I've been...

So - Im not sure if my 2016 version of excel can even perform the function I want to do. But basically - I have a list of "possible errors" for a spreadsheet that has 40+ columns and over 2k rows. I need to be able to filter for the errors (I.e. if Column AU= 0 and Column AV not = 0 OR if column...

Hello, Can anyone help me with formula to get the Output (Column C in attached image Column A and Column B have some numbers (Alpha Numeric) separated by comma. If they have any common number, then I need Column C value to be "Yes" and if not I need value to be "No". Can anyone help with...

Hi guys, how are you? Guys I don't know which one logic I need here to place dates by counties by months. I need place only earlier date in my Month cell. Example If I have date: 01.01.2020 , 05.01.2020 , 07.01.2020 then I need only earlier date from January = 01.01.2020 in cell Date 2020 I...

Hi All, I have the following code. The search works well but I would like it to work as a partial search then if several matches display a list box with each match which I can then select. I have no clue how to do this. I have looked around and not seen anything particular that I could use...

Hi, Can someone help me with the below requirement. I have data as below in the sheet1 of workbook1. Team RegionEmployee NameCurrent ManagerTS/GS26-Jul27-Jul28-Jul29-Jul30-Jul31-Jul01-Aug02-Aug03-Aug04-Aug05-Aug06-Aug07-Aug08-Aug09-Aug10-Aug11-Aug12-Aug13-AugCXYrYvYnYn XhYnmugYmCHYrXh...

I have been using excel to keep up with my inventory. When the product has been purchased, I "fill" the cell in a blue color. Now that I have thousands of products, it has become tedious searching for an item that has not been filled. Is there any way to only search for items that do not have a...

Hi, I'm trying to sort unique entries in a list of data. Currently I know how to find what I want, which can be done by the following formula: (INT(MID(F8,SEARCH(", ",A2)+2,LEN(A2)-SEARCH(", ",A2)-4) However I want to configure it to find the value in column A and paste it in column C, but...

Dear Excel Gurus, I looked through the forums to try to find a solution for this problem but was not lucky. I'm trying to put together a search box that can loop through all the workbooks in a folder and all the subfolders and find all occurences of that search string and copy them over to a...

What I am trying to do, is to paste a term from a list into a search bar and then return a value into the spreadsheet depending on whether the search yields results or not. I would like the VBA code to cycle through the list of items automatically. Search term from Column A1 - Output if class...