search

tried wholeday to solve this problem. i need to match partial text from 'title' and meet a condition 'chn' column and bring value from the index column the current formula im using couldnt add an additional condition to look into chn column, also the partial matching of text in some cases is...

Hey, I am looking for some guidance on how I might achieve the following: I have a column (column H) of full addresses, for example: 1234 SW 80th Pl, Miami, FL 33331 On another sheet, I have a list of COUNTIES in column A, and CITY in column B. COUNTY CITY Palm Beach Acacia Villas...

Hi, I Am kind of new with VBA code. I recently created a form that will populate the data also with a search function. Anyway, I am using ".xlsb" format. Unfortunately, the search is not working where the data did not appear in the 2nd list box. Your guidance is very much appreciated. I have...

Hello, I have tried VLOOKUP, HLOOKUP, and too many others to list. I think it will be easier to show: So, I have a spread sheet with several different hardware and hundreds of serial numbers. i would like to type in the serial number and see the hardware displayed.

Hello, I have 4 sheets in a workbook (Sheet1, Sheet2, Sheet3 and Sheet4) On Sheet1 I have a dropdown in B1 to select from a list of fruits. For eg. Apple, Banana, Cantaloupe, Below that dropdown there is a "Store" table with headers Store(A5), Isle(B5), Shelf(C5) On sheets 2,3 and 4, I have...

Hello, I have a sheet that needs to search for text in a column, and then return the corresponding value next to it. I need the results stacked together so that there aren't blank rows between results. I can't use VBA for this as I'm actually doing it in Google Sheets. Thank you in advance for...

I have this code, it gets the demand of a particular part no, search for a supply in another table and returns the order, date, quantity, supplier and coordinator. I tested this on a smaller sheet and it works well, but on the sheet that I need this to run I have 30k plus lines on each table, so...

Hi Hopefully a fairly simple issue to resolve... I have worksheets that track some processes automatically getting information as actions occur by date. I am trying to modify the vba and am struggling to find a way to put an OFFSET in my formula. In the simplified example below there are...

Hello, Don't know if this is possible, I have done some playing around and it has beaten me. I get a spreadsheet which has 2 different datasets on it, one below the other, the length of the data sets vary. So I am having trouble as the row the second data set start on changes. What I am...

So I have a macro that searches Ids in a a couple sheets and outputs the location of each Id in another sheet. Currently right now, it only returns sheet name and address where the Id is found. How would I return the entire row as well? Sub findIds() Application.ScreenUpdating = False...

Hello everyone! I have the following formula that extracts columns 1,2,3,6,7 from sheet1 into sheet2. =FILTER(INDEX(Sheet1!A:G,SEQUENCE(ROWS(Sheet1!A:G)),{1,2,3,6,7}),ISNUMBER(SEARCH(Sheet2!B2,Sheet1!F:F))) How can the formula be modified so that only unique records in sheet1:column2 are...

Hello everyone, I'm trying to extract data from sheet1 into sheet2. One of the columns in sheet1 contains a personal identifier along with other text. On sheet2 I use a filter function to extract data from sheet 1 by referencing cells in sheet2 column (i) that lists the personal identifiers...

Hello, I have a formula that finds a keyword in one column and places a different keyword in a seperate column and if it does not find it it is left blank. That works great but I want to do this with multiple words on the same columns. I have tried using AND/OR but it does not work. Here is...

I have 2 sheets in my workbook. I am trying to determine if the serial number value from any given row in sheet 1 exits in a column of comma separated values in row Sheet2. I have no control over how the data is exported from either system. I've tried to find and I dont get any data. I've...

Hi, I wasn't able to find the answer to my question online and have no idea what I'm doing in Excel. Out of a spreadsheet with thousands of company names and their associated data, I have a specific list of companies that I need email addresses for. Instead of manually searching for each one...

Hi, I have a dataset where it has a Date field and there are 4 or more than 4 'Resource Name' columns. The name could be repetitive in each column but it will not be repetitive in each row. Now, I have a list of unique resource name and I need to find out the max Date for a particular resource...

I have a sheet called "IDs" that contains a couple Ids. I want to loop through through each one and find the location/s where each on appears and output the location/s in a new sheet called "Results". How would I do that? Currently right now, I have a VBA macro that loops through each Id BUT it...

How would search numerous sheets for a number and output the location where it's found on a new sheet?

So I have a sheet called "Names" that has Last names in Col A and First names in Col B. I would like to loop through those names, search the other sheets where those two values are found on the same row(last name and first name are always in two seperate columns) and output the location in a new...

1. Open the file that has name, time and date 2. auto filter zero in a specific column "AL" and remove all the rows that has zero 3. disable auto-filter than save and close the file 4. copy the same file to another folder and paste it 5. delete the old file that is already there which is 30-45...