associate

Hi, I have two sheets with data. Note:- Data in both the sheet is around 90000, I am here showing only sample data for the task. Sheet Name:- "Associate Tracker" Sample Data:- <tbody> Column - A Column - J Column - S Column - Z Associate Name Calling Date Confirmation Location A...

Hello, I'm trying to match cases from my lookup list to my master list below using multiple criteria, to get the output in column H. I am able to match the "Chris Dobbs" case in row 4 by concatenating last name and gender on each of the two lists. But i cant figure out how I would find...

I am trying to combine data for users who have multiple rows into one single row. All other data is the same except for one column, so I want that one column to reflect all of the data in the first column for that user, separated by commas. Current Sample <tbody> Login_ID Sys1_ID Emp_No...

Dear All, I do have a sample data-set across A1:F6 as follows:- <tbody> Region Vendor Name String Lead Time PO Count % Mix-PO Count Desired Result North James Associate NorthJames Associate 2 4 20% North James Associate NorthJames Associate 4 10 50% 4 North James Associate NorthJames...

Hi, I have a team of 40 associates and currently, we have one excel based file with multiple columns to capture the data on a daily basis. These columns are bifurcated into Four parts: The first part, basic details: First 12 columns: Date, Month, Week #, Unique ID ( Aklphanumeric), Tracker...

I currently have the code below to find the maximum value in a column. After finding the maximum value I need to associate that number with another value in the same row but a different column. I want to find the maximum value in the range ("AX6:AX29"). I need to associate that number with a...