duplicate entries

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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