duplicate data

Hi, and thanks in advance for your help. I want to compare two columns' data and put something in the third column when there is a change; or, eliminate the duplicate info alltogether. For Example: <TBODY> Cust Num</SPAN> Contract Date</SPAN> 0010000004</SPAN> 1-Jan-10</SPAN>...

Hi, I'm trying to condense my email lists in order to stop people receiving the same email having signed up to several lists. How do I compare 5 different columns to find email addresses which appear in more than one... Any help would be much appreciated! Amanda :eeek:

hi i see lots of posts about merging but could find none that really address my problem. im trying to organize a 10k+ name donor data base list that has names of donors, with how much they have donated, every year in yearly increments starting from 2006..... the problem is that excel displays...

Using Excel 2010: I'm working with a very long list of vocabulary words & definitions and need to clean out duplicates. I followed the directions at http://www.techrepublic.com/blog/msoffice/how-to-find-duplicates-in-excel/842 to copy only unique records to another location. It worked, but...

I'm trying to create a 5 day golfing schedule for 12 players - this means there are 60 cells to fill. I want everyone to play with each other once but then have the minimum of repeats. I've tried the MRAND with INDEX which is great for each day's play but then find there are a lot of repeat...

I'm currently an XO of an Infantry Company in the Army, in charge of accounting for and managing all of the property in my Company. I have a master property book with all of my property listed on it listed in a single excel file. I have several other files listing portions of the master...

Sheet1 <TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 107px"><COL style="WIDTH: 84px"></COLGROUP><TBODY><TR...

Hi, I am working on a workbook to help me schedule vacation in my department. One thing that I am having trouble with is getting excel to return the number of days that exist in two different lists. Example: WEEK 1 REQUEST1 5/13/2012 5/10/2012 5/14/2012 5/11/2012 5/15/2012 5/12/2012 5/16/2012...

Hi All, What would be the best way to find the duplicates using values from multiple columns. Example : Concatenate value of columns A & B & C & D & G and find if this combination is repeated across the sheet and return/highlight value of Column A. (The sheet is large like 50,000 rows)...

Hello, I'm pretty new to Excel, please help with this task. The company I work is building some fenders for a customer. Each fender has an individual part name (M4599), but it's actually an assembly of various parts with different part names. What I'm trying to accomplish is being able to...

Hey all- I am setting up a workbook with multiple sheets to be a template used in the future. The first: "Providers" has the provider and insurance policy listed for every scenario. On a later sheet: "Individual", I am trying to sum data from a different sheet. In order to do this, I need to...

Can someone help me out with this? I have built a spreadsheet that uses Data Validation with the VLOOKUP function to prevent me from entering duplicate data...The formula I'm using is =ISNA(VLOOKUP(B100,B$2:B100,1,FALSE))...I am also using Conditional Formatting just in case Data Validation...

I have a column of numbers which contains numerous repeated entries and blank cells. The list is free to expand as people can continually add to the list. The list can only expand to a finite number of rows, say 150. Is it possible to use a bit of VB code to extract only unique entries and...

Working on a spreadsheet that has multiple phone numbers on same row. Looking for an "if" statement that will check for duplicate numbers in the same row and then tell me if there is a "Dup" or "No Dup" for that row. Jan Doe 555-1234 555-4321 555-1234 Dup John Doe 555-0987...

Well, I've searched the web and have apparently developed a table style that is rarely used and am having a difficult time finding help with my issue. A brief background: I'm tracking what has/has not been done to certain vehicles at our dealership (taken pictures, write a description, etc). I...

Hi, I am looking for some code help with finding duplicates and moving them to a new spreadsheet. I am looking for duplicates between Sheet 1 and Sheet 2 Col (A) "policy num". I would like the duplicates to be moved to a new sheet (Sheet 3). I would like the new sheet with the duplicates to...

Hi All, I'd like some help appending data to the bottom of a master worksheet from another active sheet in a different open workbook. For example I receive an internal order, which could have between 1 and 200 lines on it. I need to add these lines to bottom of a master schedule of order...

I have a spread sheet where the last 4 digits of the phone are duplicated in some records, looking like (212) 555-12341234. Is there a way to remove the last 4 digits of the incorrect numbers only?

I created a workbook with several worksheets. They connect to one worksheet that has several of the same drop down lists on it. I want to be able to find duplicates on the page when the same selection is used in the range I choose. I found how to do that and it works. However I could find no...

Need help! If any change in done on any cell of a row. Then macro looks for the duplicate value across Column B. If any duplicate found, then copy entire row to the row, where duplicate is found in cell in column B. The idea is to have similar rows, wherever is any duplicate in Column B...