duplicate records

  1. M

    Updating Specific Fields from Excel to Access

    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...
  2. B

    Need help in coming up with a formula or VBA macro to find the duplicate records based on multiple conditions and highlight the duplicate records foun

    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...
  3. J

    Macro for data entry that checks for duplicate record

    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...
  4. C

    VBA Code / Duplicating Records

    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...
  5. M

    How to extract duplicate records from 4 spreadsheets into a separate spreedsheet?

    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...
  6. M

    Sum of Duplicates Across Multiple Sheets

    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...
  7. K

    Identifying Duplicates (text) w/o Deleting Them All

    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...
  8. S

    I need to find / count the duplicate values in different lists.

    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...
  9. G

    re extracting duplicate records.

    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...
  10. P

    Macro to create duplicate rows based on criteria

    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?
  11. B

    Duplicate Records

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back