list all matches

I have a column of names and another to show if they have had work done on their computer. If work has been completed there will be some text in the cell, if not it will be empty. I would like a list that shows the systems that are outstanding and when I put an x in the cell next to the...

I have a large list where I'm trying to put everything into family categories. As an example, if I have the following list, a person could go through and identify that there are families of parts: ABC, ABCD, CDE, CDF, and ZZ. Sometimes the families are identified by the first 3 characters...

Hi there, and thank you in advance for helping me with this! I have a previous macro that I received help with a few years ago which has been serving me well: Original Solution's Post However, I'm running into trouble with the accuracy. Essentially, if my list of modifier words to be found...

Hi All! I work for a university and have done an audit on subjects and the specific skills required for that subject. I have a table that shows the subject's code, the skill required and when during the term their subject should receive support (before an assessment item that requires that...

Hi, Here I have a list-1 in that list need to be extract the required items only in list-2,One is high level and Second one is blank cells where yet to be decide work location priority level. and as per Priority level there should be return further values which are contains in a same row. I...

Hello, I have a workbook with Sheets 1 and 2 with data on them. This template is on Sheet 3. The template uses the cell D5 to pull data from these different sheets to populate. You type a project number (Proj#) in D5 and the rest should populate. On "Sheet 1", I have a listing of all the...

Ok I need to build a list automatically on Sheet2 (In Column A from Row 2 down). If I enter the data "Team 1" into A1 on Sheet2, I need it to pull anyones names from Sheet1 Column B. (Column A has the Team # they are on). I've tried the following and have had no luck...

Well, upfront, I have a very basic knowledge of excel software and I hope my question isn’t too lame… Having said that, I have multiple storage boxes which I need to organize. Each box holds 100 units in defined fixed positions (1-100). Units have a very dynamic range of names (#ID) and also a...

Hi I have very little experience in VBA but need to puttogether some code to save me a great deal of time. To set the scene: Each day I get a list of style numbers for products. I have to check each style number against acollection of other workbooks and copy the corresponding row(s) to a...

Hi, so I've been looking around for a kind of self-project that I have in mind. I got a list of different descriptions with variable components, basically my idea is: if I have a certain amount of this component and a certain amount of this other component, display all the matches based on the...

I receive a spreadsheet with the information listed below. The spreadsheet has a list of employees, spouse, children with DOB's and packages (Medical & Dental). I want to create a formula that extracts every employee with the relationship 1 without duplicates. My current formula extracts...

I currently have an excel sheet with 5 columns. The first 4 have data, the last column has the function: =IF(AND(D2<b3,d2>C3),A3,"") So if (TRUE) the value in column D is between the values in columns B and C it prints the corresponding value from column A to column D. If (FALSE) the function...

Hi guys, This is my first post on this forum so sorry if it's not clear but I'm hoping for some help with a formula. I'm trying to design a formula that will present people with a list of holiday destinations based upon when they'd like to go. On the sheet 'Countries' there's data with each...

I have 2 lists (many thousands of items in each list) and I need to compare these two lists and generate a list of all the duplicates. (items that show up on both lists) I can find instructions on how to DELETE duplicates, or how to HIGHLIGHT duplicates, but I need to generate a full LIST of the...

Hi Team, I have a workbook that I am trying to create and an overall Dashboard to give a snapshot of information from my main list of projects. On the main sheet we enter details about the project, unique reference numbers, and dates to show start & end of projects. There are also sections...

Hi folks, I have a list of clients in A6:A101. If criteria is met in cells D6:D101, I just entered an X. I am trying to have the names of all clients with X's in cells D6:D101 output and list in another column. The formula is in AB6. As you can see, I have it working for cell AB6, but it is...

Hello, I have a list of recipes, say recipe 1-10 in the B column (and these recipes have hyperlinks to other sheets where the recipe actually are, more on this in a minute). I have check boxes that are linked to their corresponding cells horizontally. What I am trying to do is create a list...

Hi Everyone, I have a challenge that is failing to take root in my brain, and I'm hoping that someone will have a great idea, if not an actual solution. Here's my situation: I have a list of charitable membership (about 7000 people) and a list of projects that those members have expressed...

Hi Helpers, I'm not sure if this is indeed possible, but thought i'd give it a go as you all have been so helpful in the past. I have two tables in two separate worksheets ("WKST1" and "INV2") as shown below. INV2 references WKST1. In Column D of INV2 I am using a SUMIF equation to total all...

Is there an "in" array formula option or equivalent? So item in list: return item Anyway, for problem I need to check people names against a list of names derived from SharePoint entry and return the offset of them attending(possibly multiple events) and what event. So say this was the...