search

How would I find the last combination of a letter and number in a list? A = Combinations B = Results for A C = Results for D A1 A2 D1 A3 A4 D2 and so on...(not a pattern, just the result of previous selections). So I would need Column B to return the last combination starting with "A", which...

I've just hit a wall here and my brain refuses to bring this information up. I have a cell with a series of room names in it, separated by commas: Master Bedroom, Master Bathroom, Laundry Room, Stairs, etc. Call this A1 In "D1" I'd like to place a formula that will take those room names and...

Hi I have a UserForm that has a filter Combobox that filters different criteria. and that includes "Year" and a TextBox which will be the search box. and a listbox that will show result Note: "Year" is in separate column ("T") the search box is working fine for other criteria, except for...

In column A, I've got a list of companies (non-public so no stock ticker symbols) and what I'd like to do is create a formula that launches a google/bing search that puts the name of the CEO in Column B. A B Acme =FormulaX? (A: search "CEO of" A)

I found the following VBA code here which search file word by word and page by page and returns the page number. I wish that it could be modified to search the file page by page NOT word by word and return page number. Then it will be more fast in my opinion. Sub FindTextAcroAll() Dim FindWord...

I have three tabs in a file, one is a list of projects and looks something like this: Project Number Project Name 1234 Sales Software Development 4567 Marketing materials 7894 Furniture Purchase 8829 Sales Suite Fit Out on tab two I have an invoice log where i enter all the...

Hi all, I need to create a formula to Filter a list and return all cleanings that took place between a certain time frame. How do I go about creating a search within the filter function that will search between the two times on a certain day? Do I need to bring in an Index-Match? This is what...

Hello all! I have a question regarding looking up similar companies. For example, in my database, there is AXA Asia, AXA Group or AXA Company Limited. I will look up AXA with search function and filter them out. My formula is like this...

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