matching

Hi All, I have a strange request. I have attached this workbook of sample data. qualnames.xlsx Sheet 1 has a list of required positions. Sheet 2 has a list of all the people that are qualified for a position listed on Sheet 1. How can I have Excel fill names into sheet 1 column B from Sheet...

hello everyone. I wasn't able to locate the answer that I need from previous posts so here's my problem: our system automatically generates a large data spreadsheet and the problem lies in one column. That column contains dates & has specific colour to identify what the date is for (see attached...

SITUATION An Excel sheet with 3 columns: 1. Column A - 28 personality traits (e.g. adventurous, reliable, etc.). The 28 personality traits are labeled using 1 word. 2. Column B - X coordinate of the personality trait (between 0 and 100) 3. Column C - Y coordinate of the personality trait...

Hello, I am trying to find a formula to return the value of the duplicated number in cells that are not right next to each other, but within the same row. In the below example, I need a formula in column I that does the following: If the variance to on-hand in column D is zero then return 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...

So, i have a 'Summary' workbook that consists of zone, state, city, and total income. Inside one zone, there are a states. And inside the states, there are a cities. What i'm trying to do is to find the total income of each city in column D and summarize the total income of each state. To get...

Hi, I have two sets of data, one is a column with a certain set of numbers, lets say 11111 33333 55555 Then, i have a second set of data, that is partially made up of this first set of numbers. Each number is matched up with another column. it looks like this: 11111 abc 22222 def 33333 ghi...

So currently I got multiple guys name john in my excel, how do I ensure that my vba doesn't go through the same cell over and over again? this the code I'm working with Sub match_Data() Dim rSH As Worksheet Dim sSh As Worksheet Set rSH = ThisWorkbook.Sheets("Master") Set sSh =...

Each week I have to scan a changing list of names that includes former students. I want to find each student listed. My problem is that the list is outside my control and sometimes students names are presented differently depending on who creates that weekly list. Often Thomas becomes Tom...

The messy data looks like the list in columns A & B (see image), the finished list needs to be like columns D&E. I'm cleaning up some very messy data with formulas on the spreadsheet up to this point but the solution could be with VBA also, I'm open to either. So basically the purchase order...

Hello All, If anyone knows how I have a large data set and I would like to check there is duplicates. Issue is there are two parameters needed to confirm this. So for example I have in Cell B3 the Activity ID “BLH7895“ and in Cell C3 I have the Activity Name “Taking out the trash”. How would I...

I am starting a new project to simplify an uploading process. I would like to create a workbook that is set up like this: Two sheets, one is called “Upload Data”, and the other is called “Prepared File. The “Prepared File” sheet has the column headers in the correct order for the upload to work...

I have 2 sheets - "AE" Sheet (representing "Day" & "AE" columns below) and "TC" Sheet (rep "Date" & "TC" columns Below). I need to do matching of both sheets. With the VBA code below, I was able to perform the ff matching procedures 1.) Single amount matching 1:1 and 2.) Single to Combination...

Hi All, I have a data of all positive and negative values like -400 200 200 -100 100 -500 250 250 300 -150 -150 I have multiple formulas to identify the matching numbers but all i want is modifications I have data in A1:A100 I use the B1...

Hi everyone, I have a userform that has 2 textboxes to add data to a worksheet, this all works fine although i would like it to also search a worksheet called "Members" for a matching value entered into my first textbox called "txtMemFirst" if no matching name is found then it needs to show a...

I have two sheets of data. One is vendor payments, the other general vendor data from their master file. I need to add their federal tax id to the vendor payment sheet by matching the vendor numbers on each sheet. What’s the best way to do this?

Hello Excel Experts, I have 2 Excel files, the first has cells with the following data: [Name] [Cost] [Date] The second file has: [Name] [SKU] [Serial Numbers (can be more than 1)] I'm trying to combine these into a new file with: [Name] [SKU] [Serial Numbers] [Cost], based on the...

Hello All, I encountered a situation that I need your help with a formula to get the result as shown “result” range row J1:X1. The calculation based on weekly updated table on the left. If found a MATCH number from the “numberID” row J2:X2 in the Category row “A, B, L1A, L2UA, and T” , then...

Hi I have set-up the below but the LEN calculation seems wrong as LEN that isn't 15 is matching and doing the workday function. Can anyone see what is wrong please?

Good day All, I need to extract data from an excel sheet and index them on another sheet to formulate results with handicaps etc. I am struggling on extracting the data: <tbody> Division Stage Number Name Hit Factor Classic 1 Ira 2.57 Classic 2 Ira 0.97 Standard 1 Jason 5.36 Standard...