list

Hello All, I have a small script that takes values from one sheet and populates other tabs based on specific criteria. I have a small declaration of variables that I am trying to validate that there are values within the variables, if not I want to change the variables to "N/A" as the...

I have two different brand lists in two different columns, New List and Reference List. I want to make a formula that returns only the matches between two columns, as shown in the table below. New List Reference List Formula Returns Brand D Brand A Brand D Brand Y Brand B Brand B Brand...

Column A contains strings Column D Contains a list of words to search for Column B returns true if whole word found Only return true if whole word is found eg Dog not DogD If not in list return a null cell ---- If possible I would a more detailed result Column A contains strings Column D...

Hey all!! I have a unique problem... pardon the pun haha. I have a really simple equation =IFERROR(UNIQUE('Lims Report'!D7:D5000,FALSE,FALSE),"") This formula has always worked for a simple list with no duplicates, and now I have a list using this formula that has given me a duplicate :( Has...

I have a problem, want to mirror a drop down list on 2 sheets so that when one or other is changed they both change to that same value I have created the first drop down list using DATA VALIDATION from a table on another sheet. I have then gone on to my second sheet where I want the mirrored...

Hi everyone, I have a question I'm not sure if excel is able to do. If I have a list of businesses in excel and want to search the web (probably google) for their website address. Is there a formula or a way to upload my list somewhere and have each business googled and return their website...

Hi all, I have a giant database of NBA players and their NBA 2k ratings, what I'm trying to do is automatically pull them into team lists: To get the starting 5 I use this formula in column C...

Hi, Required a formula help to Extract and return a rows which contains alphabetical text, and return a list wise cells values which contains alphabetical text as based on data specified in column(B4:E8) desired results enclosed. Thanks for the help...

Can anyone help me please, I'm trying to find blank cells in a range (O2142:O2206) and the get reference to those cells. And is there a way to only get reference to the row. see image below: I want it to look for the blank cells in column O (Date Job Delivered) because if there is cells...

Dear community, In Excel, I am building a small database with information on employees, clients, invoices, etc. I have a separate file with some macros that I use to generate invoices. There are 3 things that I would like to have, where the first is required and the other 2 are nice to have...

Hey there, First of all, I want to clear that is my first time to dive into excel that deep so please be patient. What I want is to calculate the minimum number of toilet fixtures upon occupancy classification and occupant load. For example: There is a classification called an assembly that...

Hey there, Basically, i want to create an extremely basic version of OneNote but with a retro style. I lack the programming skills to create this (ive been trying), but i was wondering if maybe it could be done in Excel? Is there a way to create a sort of directory tree of excel sheets within...

Hello, I have been trying to find a solution to creating a Data Validation List that shows a default value (the top item in the list). I found a solution on this board that sort of works. Is it Possible for a Drop Down Menu to have Default Selections? Post #3 seems to work....but only to a...

Hi Everyone, I have a function I am trying to build out and could use some guidance/coaching please. I have a worksheet in a workbook that contains a table which is refreshed from a SharePoint list. What I want to do is, whenever this worksheet/table is refreshed it copies across only what is...

Does anyone have any experience with a macro the creates a new button, the new button created then has code created for it based on a template so that when it is run it will do as specified. It creating a list that has a button on each row where you can delete that line or tick done. I also...

Hi all, I’ve got a sheet with 4 tables on it. I have a cell in B2 with data validation set to a list on another sheet. I can currently hide or show the tables based on either columns or rows. As one table is shown the others are hidden. What I’m wandering is if it is possible to hide or...

Hello everybody, I am currently managing a list of materials for different sections: The top of the list looks like this: I have about 6 sections (EM, Formulering, Inspektion & more - please let me know if you want all the names). I want to create some sort of pivot table (I assume? I...

Hi all, I have developed a tool which creates a new list in sharepoint when I run a macro. But its takes datatypes of column only as 1) Single line of text 2) Number 3) Date But I have a column in excel which has a drop down options but after running he marco, when I check my sharepoint list...

Hello everybody, I currently have the following list: I want to create a formula (probably through conditional formatting i'd imagine), that basically says: If the cell 4 turns to the left of any designated cell (A1) in row E is not = blank, color the cell in row E with a red...

Hi, I have an Excel file that utilize Excel Data Validation - List by link to another sheet. However, the list seems not in the same pattern due to data were add up later in another sheet. so, the row at top part link to a number of rows while the bottom part link to data in more rows which...