remove duplicates

My current code is below. The problem is in column 9 I have over 2000 possible different values but I do not want to remove duplicates for rows that contain "VNASTG" in column 9. Sheets("Data").Range("A4:I300000").RemoveDuplicates Columns:=Array(1, 2, 9), Header:= _ xlYes

hi friends! i'm using filter formula to build my list in column A. I have example of the formula in column D. what i am attempting to do is create a column like C where the duplicates are removed, only leaving the first occurring number. ideally I would like to wrap this formula around the...

Hi! Thank you for reading this one. For an example of what I am trying to do, lets say I have a sheet that is about 200 rows long by 15 columns wide. It is one sheet with multiple bills-of-materials stacked one on top of the other. Column A has the master/parent numbers and Column B has all of...

Hi Master Excel Users. I have a two dimensional cell range of cells say from A1 to P5000 I would like to remove all duplicates within this range but keep the uniques where they currently are sitting, in their current position. Any good way of doing that? Alot of cells are blank within this...

Please help with the following Macro: At the stroke of a key eg. (Cntl R) <colgroup><col></colgroup><tbody> Select entire column A Sort Column A Remove duplicates in column A select entire column B Sort Column B Remove duplicates in column B Cut all data from B1 to last non empty...

Hi Guys, Let me set the scene. I have a transactional database that creates duplicates… Theduplicates will have a matching reference, they may have a matching paymentamount but they will have different dates. I have the data in Excel format. I need to remove all duplicates where the...

Hi, i’ve started using VBA at my work and have stumbled on what seems like a very simple problem, but I am unable to see any answers that suit my needs on here. Basically, I have Column A on sheet 1, and Column A on sheet2, and they have about 30,000 rows on each. I want to copy and paste, as...

looking for a way to remove duplicate data wile entering data without any popup messages

Hi, I have been looking in the forum if anyone have found a solution to the problem when using remove duplicates in Excel for Mac 2016 a popup window appears that doesn't allow the code to continue. I have spent some time looking for a workaround and it seems that issue hasn't been resolved...

Hello folks: I have the following spreadsheet: <tbody> Where Who Time CardNum Building 2 Entry A Smith, Brian 6:52:00 2498 Building 2 Entry A Smith, Brian 8:33:00 2498 Building 2 Entry A Smith, Brian 7:38:00 2498 Building 2 Entry A Doe, John 11:59:00 41880 Building 2 Entry A...

I'm trying to build an interface that will allow others to select a specific product that will then give a subset of that specific lot. For instance my first list would be something like: Product Type Inventory Apple Red 2 Pickle Sweet 1 Orange...

It's possibly my search-fu is failing me here, or more likely I simply don't understand the answers I've found. I'm working on a project (due to some backend db errors that will eventually be resolved) that requires me to tabulate the duration of certain phone states. Unfortunately, the...

Hi all, I have 3 queries, one returning a large list of "all" records and the other two are different subsets of this data... what I'm trying to do in Power Query is reference the "All Records" query and then remove or filter out any records that are found in the other two tables... resulting in...

Good morning all! I'm relatively new to Power Query and I'm having trouble removing the duplicates in one column after sorting rows. I've searched all over and found a few things that seem to indicate that Power Query uses the Source Order to determine which file to keep. Since I am importing...

Hi All, I'm using this current code which works fine until i have more than the specified amount of rows, I tried replacing the highlighted line of code with: "ActiveSheet.Range("A1:K" & Lastrow).RemoveDuplicates Columns:=2, Header:=xlYes" but I get an error. :mad: Anybody have any...

Hi all im one formula away from getting my spreadsheet to look and do everything it needs to do. I have 2 tabs old system and new system and a formula that copies all the data over and sorts them in a third tab. In the 3rd tab in column A is their name. Everybody should have 2 entries in the...

Hello all, I'm look for a way to remove duplicate values that are not an exact match. The processes from everywhere I look seem to not work. Example: Original values: Wal-mart #2501 Wal-mart #2600 Wal-mart #5164 Change to new value: Walmart Thanks for any and all help

I have a column of names that I put together from two different lists. The list will mostly be duplicates, as they are similar sets of names from different sources. However, there will be some names that were included on one and not the other, or there may be different spelling/versions of the...

Hi Everyone, Please can you suggest ways using excel and excel vba for removing duplicates. Thanks

Hi I want a macro to remove duplicates based on the set of criteria I've articulated below, is this possible? If Column C value is greater than Column E value then Select rows with identical Column C value and remove duplicate rows based on values in Column A, B, C, D else Select rows with...