duplicate entries

  1. R

    Transaction Matching and Naming

    My Excel data table has 100K rows. The rows in column A are reference numbers ending in either ".0" or ".1". Corresponding rows in column B have a transaction name but only where the column A reference ends with ".0". There are no transaction names in column B where column A rows end with a ".1"...
  2. M

    Duplicate entry on different sheet

    Hello out there, hopefully someone can help with this. I have a workbook where data is entered on the first sheet (DATA SHEET) and then sent to numerous other sheets depending on the data entered. I would like a code to check column D in sheet 2 against a cell in my DATA SHEET to make sure that...
  3. 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...
  4. E

    merging duplicate donors and donation amounts from different years

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

    Need to see duplicate data in my pivot table

    I have a spread sheet of medical information, what my insurance covered, and what I will have to pay. There are several recurring amounts that have different dates, but I can't get my pivot table to show the separate entries - it only shows one entry per billed amount. Is there a way to have...
  6. B

    Remove duplicates in multiple columns and return the names in one column horizontally

    Hi, I don't have the Excel skills or knowledge to even attempt this so it will be easier to show the before and after of what I'm trying to achieve. I desperately need to change this source data: <tbody> User Name Entity Code Business Area Level 1 Level 2 Level 3 Level 4 Howard Ratner...
  7. 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...
  8. K

    Multiple List Clear

    I have a list on sheet3 that is generated by a user and a list on sheet2 that is automatically provided. What I would like to have happen is when when a macro is run on sheet3 it goes down the list (could be variable in length) item by item and clears any identical values in sheet2. For...
  9. J

    Dynamic Range to not include Blank Values (even if cell has formula)

    Hi guys, I've got this table below whereby row C contains data inputted by a user and there could be duplicate entries, so I've got formulas in Column A and B that remove the duplicate entries, as you can see: Excel WorkbookABCD1EntityAdditional Sheets to...
  10. J

    vlookup with employees with the same shift

    So I have been working on a sales floor planner that pulls a ton of info onto one sheet that would be printed out every day. Part of this sheet is the schedule for the day. I have a dummy workbook showing how I am pulling data but I have a vlookup problem where if more than one person is working...
  11. A

    How to get rid of Duplicate Value in Query Access

    How can i get rid of Duplicates from Access query, i just want to get unuiqe values out of my query. If there is code or something add up that can get rid off, Please Post.
  12. A

    Mass Mailing Mail Merge, Help Needed!

    Hello Everyone! My Boss is running for public office and we need to do a mass mailing. In order to cut down on expenses; however, we need to consolidate the fields in excel to eliminate the households with more than 1 registered voter (so they dont receive multiple mailings), or, if possible...
  13. L

    Conditional formatting to highlight duplicate entries

    Hi, I need to highlight duplicate entries in a range using conditional formatting. My problem is something different. I will use numbers and text "NA" in the range. I want only duplicate numbers to be highlighted and not the text "NA" Can anyone help me? Thanks, Kamal
  14. L

    To prevent duplicate entries using Data validation.

    Hi, I juz wanna prevent the duplicate entries in a range using the data validation. I know , we can use the "custom list" in data validation and use the formula =countif(range,criteria)=1 to prevent the duplicates. But My problem is typical..In the selected range, i will use the text "NA" and...
  15. C

    Excel restrict duplicate entry from two lists

    I wish to use data validation to restrict duplicate entry into a cell from two lists. I can set it up for example using =COUNTIF($B$2:$B$80,B39)=1 in data validation but I need to also check against entries in cells F2 to F80 to ensure a duplicate is not entered in B39. Any ideas how this...
  16. S

    Duplicating cell content x times

    i need to copy a word x times in a spreadsheet (these are search terms that I am trying to duplicate to generate a cloud tag - so need to capture not just the word by also the frequency it occurring at. Is there an excel formula I can use to do this? My data looks something like this: Buy...
  17. S

    Merge cells / wrap text / based on duplicates

    Hi all, I'm new here, so if this is already posted in another tread, please forgive my newbidity for not finding it. My question is... ...is possible to merge certain cells in column B, make them wrap text every time a new cell is added to the merge, and base the merge on duplicate fields in...
  18. J

    Dupicate search

    I would like when entering an identification # to be able to have Excel automatically search the same column to find if it was previously in the database, and if so, to place a "1" if it has been repeated or a "2" if it has not in another column. I was thinking I would need an IF function to do...
  19. R

    3 Dimensional data vaildation with no duplicacy

    HI.... I want to create a dynamic data validation sheet... for insitance suppose i have a following database in excel... Aggregate Sub-Aggregate Grade Plastic PP Injection Plastic PP Extrusion Plastic pc...
  20. kylee

    Workbook duplicates paste to new sheet

    Hi all, I've decided to start getting serious about saving money. I'm a spender in a BIG way and it's got to stop! Therefore, I'm creating price sheets so that I can get different answers to some buying questions. There are four sheets in the "Price Check" Master Workbook - they are the store...

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
Back
Top