duplicate records

I consider myself relatively dangerous in regards to VBA, Access and Excel. I have a simple table in Access that feeds a Dashboard and PivotTables in my Excel project. Monthly I receive a new spreadsheet of data that has to be imported into my database in Access. Here lies the problem...

Hi, I am trying to come up with a formula or an excel VBA macro to identify the duplicate records present in an excel sheet based on multiple criterion and highlight the duplicate records found. I am using Excel 2010. Here is the sample data which I have and criterion to consider 2 records to...

Hello Forum! I have a spreadsheet that uses a Form for Data entry. Each record has ID, Name, State, and about 20 more columns of information for each ID. The data entry is working well. What I need now is to add a check for a UNIQUE ID. If they are adding a new record I need my form to...

Hey Excel Gurus, I have found online a really good piece of vba code but unfortunelaty I can not update it myself as I am a new to VBA. The below code duplicate record based on a constant in cell d (ie qty 5) and add an incremental number to the new duplicated records The issue is that when...

Hi Fellows, I have 3-4 excel spreadsheets with same sort of data. Each spreadsheet has 1000+ records, and each record has data ranging from column A to Z. Some records are duplicate within these 4 spreadsheets. Now, I want to extract the duplicates into new spreadsheet like; every record has...

Hello All, I searched the forum and was unable to find a simple(?) answer to what I need. 1 workbook with 5 sheets Column B contains inventory item numbers Column F contains counts There are several duplicate entries and I need to consolidate the counts from all sheets so that they can be...

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 sorry, but I know nothing about Excel. I know very little about anything when it comes to computers, but I'm here to ask for your kind help. Google just told me that Excel can compute info into statistics, and statistics is what I need. Me and my friends have ran a test on how colors affect...

I am fairly new to Excel. Lately have been using a sumproduct formula to compare rows and colums to find duplicate records for genealogy, Name, Date of Birth, Date of Death, however if the text is in all CAPS or Mixed, this formula does not seem to pick out the fact it is the same. Is there any...

To do a mail merge I need to duplicate some Excel records X times where X is determined by a value in one of the columns. Any help?

I am trying to remove ALL duplicate records including the initial record. Using the "unique records only" leaves a version of the record. ie: Red Red Yellow Pink Green Green Blue with the "unique records only" function will leave you with Red Yellow Pink Green Blue I need something...