search

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

Quite a complicated question for Excel, I think, but okay... There are 10 thousand lines. For each unique string, need to find matching strings using substrings. That is: 1) yellow apple, ..., 9999) golden apple - input values. 1)Yellow apple and 9999)golden apple are output values that need to...

Hi, I needed a similar array formula in the past and was helped hugely by this forum. But I can't replicate for a different context. I'm looking for an array formula that will allow me to search for a value (in a table in a different sheet), and then return all the neighbouring cell values to...

Hello, I really need some help breaking down this formula please :) I currently have a document that I am working on where I have created a field that allows you to search for the relevant information below by entering in the postcode and the suburb. The screenshot below is a sample of the...

I have got an issue that I can't workout. I need to perform a SUMPRODUCT with multiple AND and OR criterias. something like the following...

Good day everyone, I'm quite new to the site but known it for a while. I would like to ask for your help in automating an excel file to perform a task. In particular, I have a table where in the first column theres a list on names and across there is a list of abilitations. The table is filled...

Hi team, Wondering if it is possible to have a VBA to look in between blank rows and return specific cells in a copy paste function to another sheet. I essentially need a VBA that will search between blank rows and return specific cells and copy them to another sheet The paste format would be...

Is there any way to find whether excel workbook has any 8 digit number. E.g. 12345678,112233144 etc. could be in entire column or within in a statement on any of the tab of excel workbook. I need excel to find out any number(if any) in excel workbook. examples of 8 digit number could be present...

Hey everyone, I am tryin to search keywords in a big text but cant figure out how. I have a cell with a big text in it and I want to find keywords in that text, if a keyword is found I would like for it to be displayed. To give a more clear example I made an XL2BB below. I would love for it to...

I have a field of data which needs to be compared in multiple places, I keep almost getting there but am missing the final bit to make it work, would appreciate any assistance with this! One table of data has an individually coded number which needs to be searched for in the other table of...

Hi, I am trying to find text in one spreadsheet ("PerformanceT2") in column ("E") and the copy cells from the row in which text was found from columns ("E") ("F") and ("V") from that spreadsheet ("PerformanceT2") and then copy these cells into different spreadsheet ("Cal.PerfT") and paste them...

Hi All, I have a three sheets, Sheet 1, Sheet 2, Sheet 3. Sheet 1 has Id's and email addresses columns, Each Id has many emails, sometimes blanks too,. Each Id has multiple rows in Sheet 1. Sheet 2 has list of keywords words to use as exclude lists for email addresses. Sheet 3 has Id's, and...

I am very new to VBA and have been learning as I go on a work project. One of the things that was requested was to have a search bar to find other files of a similar problem solving event. What I want to be able to do to have a vba program that opens file explorer and searches by tags. but all...