duplicate data

Hi All, May i know how could i achieve below task : I have a below excel with data as follows : <tbody> ID Resource ABC Employee XYZ Customer Agent </tbody> Depending up the number of resources assigned to the ID in the adjacent row, the ID should get duplicated N times as below...

Hi! This is my first question on this forum so I will try to be clear and specific as possible. I know it can get frustrating when you guys have to give solutions of unclear questions.:p - My purpose · I have a database of patients, and a userform allows me to manage this database...

Hi all, To give you an overview of what i'm trying to achieve. We have 280k of registered users (last 2 years regs) and we have a subset of 116k users that have opted into our marketing etc (this covers a longer time period). We have a massive service change and have a desire to tailor our...

Hi all, Thanks for all of the help previously. Here's a problem I'm having: I am using the .find method in a Do...While Loop to find duplicate values, but I want the loop to stop when it gets to the bottom of the range, not wrap around and search from the top (another way to put it would be...

Hi Experts, Would need to have output as shown below. I am trying to figure out the right formula to be applied in Col "Output" to return value of ColB (those match in namedrange Members) when it finds first time match based on same value in ColA and the earliest datetime in ColC. For example...

Hi there, I have an excel problem. I have set up quite a complex workbook over multiple sheets. I have a list of names from one sheet, as below: Adam 1 Emily 3 Emily 3 Emily 3 John 2 John 2 Basically, this counts the number of times a name is mentioned in a previous sheet. What I want to...

Hi all - a data entry question but on a scale that needs automation/formula to build: In the example below, Sheet 2 is my master source of clients and values and Sheet 1 I am building from scratch as a sort of Account Plan/Summary "database" with actions (in the absence of a company CRM...

I have to match unique ID's using names from one sheet to the other. The problem is the sheet I'm matching to has some people with the same name so when I get the ID it could not be the right one. That's why I need to compare dates of termination and see if they're similar, so I want to go...

Hello All, I've been lurking through these forums in search of a result for my problem and could not find a complete solution. So I made an account to see if someone out there can help me out. I have a word document that I get regularly that contains hundreds of IP address along with text in...

Hi everyone, I have a single column of data in Column A that looks like this: Joe Joe Joe John John Josh Josh Josh Josh Can someone please provide me with code that would sum the number of Joes, Johns, and Joshs and put the sum for each name in the adjacement column. Thank you in advance...

Hi, I have a data range in columns A:G. I want to remove data in each row in columns A:G based on duplicate values in column G. The following code works well to remove duplicates in column G alone however I want to remove the data in all columns of the row with the duplicate value. Any help...

Hi all, long-time anon, first-time poster. I'm a little stuck. I have a massive sheet of raw sales data that I'm trying to analyze to see if we paid what we're supposed to be paying; however, the sales data is only in a per month basis. I've figured out how to get the unit price we're paying...

Good day, I am working on a Macro for one of my coworkers that should delete duplicate rows based on Social Security Numbers in Column A. Right now, I have it deleting the duplicate row, but I need to add a condition that if one (or both) duplicate rows contain data outside of Column A's SSN...

Hi Guys I have a pre-filled column up to about 100 of SKU numbers. I have checked there are no duplicates currently. I have tried adding the COUNTIF function to stop duplicates but this only works for hand typed entries. I need a solution to stop duplicates hand typed or pasted in please can...

I have a spreadsheet with about 5000 postal codes. I don't need this many because I'm using this to create a map showing approximate delivery locations. So I would like to remove the postal codes which have the same first 3 characters. For example, here is a sample list: A0A 2J0 A0A 2M0 A0A...

Hey everyone, Newbie here using Excel 2007. I've googled so many different ways, tried VBA codes, tried making match case formulas, and nothing seems to work since most compare columns. Scenario: - have a sheet with several columns (headers: account names, IDs, revenue, margins, etc.) - need...

Hi I am a beginner in VBA scripting but I am working on a sheet where I want to copy data in one cell to multiple cells in the same row as long as it is not empty but separate the two data by a comma and do this through out the table Before Macro...

Hi Team, I'm in need of an excel formula or VBA Code that can assist me reference column of unique values (Column A) and have each of them duplicated in 11 rows of another column (Column B). For example: <TBODY> Column A Column B Apple Apple Orange Apple Mango Apple Apple Apple...

Any help would be appreciated. I have a set of dates that run across a row horizontally. Under the dates I enter specific values that go along with the dates. Example: DATES:8/12/14 l 8/13/14 l 8/14/14 l 8/15/14 l 8/16/14 ENTERED VALUES: HK299 HK300 HK301 I must drag/extend the dates along...

I am trying to create an array that references a range to fill the array. The problem I am running into is that the reference range contains a lot of duplicate values and I only need unique values added into the array. Does anyone have a good sample code that can either remove duplicates from...