search

Hello In C1 i'd like to be able to type a name and when the search button is clicked, excel performs the search function. I've tried recording a macro for this but it keeps going to an incorrect cell. Is someone able to help with VB that I can assign to the button? Many Thanks

I have a spreadsheet that I am trying to populate by using an array formula. Right now, I have a formula that looks in a range and identifies if the word "Spouse" is within it. However, I would like to update the formula to search for "Spouse" & "Ex-Spouse" within the same range, but my current...

Hi, I have created a database, where data from the userform is entered into the Worksheet ("data_entry") into the respective column. Now I want to load counter readings (in a production of components) automatically into the Userform. As soon as the respective component is selected via the...

I havr data in Column AD that has the same date in column AC but no on the same rows. Column L is connected to column AC and AD but the corresponding rows has different names. I want to display the Name on Column L that is connected to column AD and display it on the row where Column AC has a...

If I search for this text "GEN2-08C" within workbook and by row using find all, it's not finding the same string on the next tab. They are both text and not a formula. If I only change the search by to columns it then finds both. I have always had issues with the Excel Find tool. Most times...

I have 2 tables on separate tabs that I would like to search for any row containing a criteria and return the whole row. After converting the data to tables I create a new tab just for my search and am using cell B3 as my search criteria text box. I am using the following formula and no matter...

I want to isolate the "EF" with the following 6 numbers (always 6 numbers, sometimes with space between). I have replaced "EF" with "-EF" so I have a prefix to these, but can't seem to just isolate the 8 character string, without having the post text or some numbers deleted. Does anyone know...

Hello and help! I am trying to set up a conditional formatting formula that highlights similar values in the same column (Column U) listed more than 2 times. The issue is that I need the formula to only match the text before the "/" character, since the number will always be unique. Example...

Good morning, I have this text, (and it changes but it'll always be annual. Feb-Jan, July-June, etc.) and I need to pull the starting date from the cell. For the Period: May 01, 2021 to January 30, 2022 I currently have this formula but it'll only work for some of the months, not all. For...

I have 2 text box (not a user form) in one text box the user is supposed to type the employee number (TextBox1) and when they click on the "search" button, it should bring in the TextBox2 the name according to the employee number. The sheet where the textboxes are located is called "Input" and...

A B 06-01-2023 22:33 07-01-2023 21:00 =A4-[last non blank cell] Objective is to find last non-blank cell value looking from current row in reverse. Amount of blank cells from current row can vary.

I'm in the process of making a training tracker for multiple office sections. I was able to create a data entry form that will send an individual's information to the sheet for their respective section. However, the only solution I could think of to easily update old information without making a...

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