search

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...

HI, I'm trying to do the Median equivalent of AVERAGEIF(A1:A10,"*"&C12"&*",B1:B10) where Column C has text some of which is contained within a longer string in Column A and Column B has numerical values that I want to find the median of. I found other threads where this was possible with the...

The situation is as follows: I have a "main table" which is *full* of data. Im talkin abut 1500 entries. Then i have another table, which is for filtering. I have already figured out how to filter the table for what im looking at. But what i now need is a way to search for a selected value...

Hello, I was looking for various solutions on the Internet, but I didn't find anything that could help me. So here's the code: Private Sub TextBox1_Change() Dim foundRng As Range Set haslo = TextBox1 Set foundRng = Range("D3:D19").Find(haslo) If foundRng Is Nothing Then...

I am in VBA H**L right now. Here is what I need the Search Loop to do. In Column A cell "A2" is a changing value depending on the person selected. This is basically a RecordId column. Starring In Column H cell "H2:JZ2" are changing values. These values could be nothing (empty), or contain...

Hi guys! I'm importing PDF-files into Excel in Office365 environment, using PowerQuery's new-ish PDF file support. However, given there are some minor differences over files, PowerQuery / Excel parses data a bit differently, based on individual PDF. I'm counting on the number of imported rows...

Hi hope someone can help I have a vba that is working really well but i need to modify it slightly, currently it’s searching dependent on the value of a cell, searchvalue = reportsheet.Range (”C2”) .Value this works fine if the content in “C2” is exactly right, but I’m using for ref numbers...

With below formula I am counting unique values. Everything worked well until I added the dates. Any suggestions to solve this? Picture attached =SUM(--(FREQUENCY(IF((N:N="Installer/Contractor")*(ISNUMBER(SEARCH("|"&I:I&"|";"|Visit|Online Meeting|Webinar|Join Visit|")))*(ISNUMBER(SEARCH("Ole...

Hi! I'm trying to trying to automate a lookup process in VBA, but I can't really get it to work. Would really appreciate if anyone could help me with this. So, here's what I'm trying to do: I want to automatically populate cell F4 with a number wich is in the first part of a string on a...

Hello, This is my first post so please go easy on me!! I have an excel file that allows me to enter in data in 2 cells and return any matching values, it works great but when it returns the data it is not returning the cell color. So when a cell matches it should bring back the content and...