duplicate

Hi, I am working on a massive data set containing more than 100,000 rows for a project. I am told to remove all duplicate data or rows that have been entered by mistake but when I highlight the data and click the " Remove Duplicates" button i get a message that there is no duplicates to remove...

I need to indicate in the rows of column C where the the first duplicate value of Column A is when Column B is not blank. Any ideas? See below example <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> Column A Column B Column C 12345 abc X 12345...

I have a table with about 10 fields. What I am trying to do is keep track of data changes; What changed and when they change. I am thinking that when the user wants to change data that they duplicate the record and then modify the duplicate record. I have fields that show date/userId so that...

Hello, I cant figure out how to do a "double search" in a column. Conditional formatting would be better but entering a formula along a row could do. Hopefully I can explain what I am tryin to do. I am trying to find duplicates within a column (F through S), then in the duplicate row see, if...

Good morning, Please help me out with macros that would cleared out duplicate dates on column A but keep all rows. For example clear out the one I have it in red. <tbody> A B C D 1 10/15/2019 lesson plans TBA TBA 2 10/15/2019 homework TBA TBA 3 10/15/2019 extra credit TBA TBA 4...

Hi I had this macro that compared data between sheets 1 and 2 and marked "OK" "MISSING" and "DUPLICATE" What im trying to amend it to do is to mark "OK" and "DUPLICATE" on sheet 1 still but when data is on sheet 2 but not on sheet 1 I need it marked "MISSING" on the row concerned on sheet 2...

I have 2 columns representing points P in the x-y plane, e.g. Pn xn yn P1 2 3 P2 1 2 P3 9 6 P4 2 5 P5 1 2 P6 2 5 How can I find the number of duplicate points (e.g. 2 here)? Needs to be via formula, not manually or code.

Hi! I'm looking for a formula to do the following: I have: <tbody> A B C D E F G H I 1 <colgroup><col width="68"></colgroup><tbody> 2040899 </tbody> <colgroup><col width="68"></colgroup><tbody> 54Z4 </tbody> 2 <colgroup><col...

Hi, I've been struggling with this formula for a little while now. Basically, I want it to return True if any numbers are repeated in the range B8:DG22 however, I want it to ignore text or more precisely, the word "Blank". =SUMPRODUCT(COUNTIFS(B8:DG22,"<>Blank",B8:DG22,B8:DG22)-1)>0 Can...

Hello, I am just starting to learn formulas in Excel. I have created a "count if" formula looking at multiple columns but I need to exclude duplicate rows based on a value (being a number) listed in column A. My current formula looks like this: =COUNTIFS(E2:E1000,"NO",H2:H1000,"NOTIFICATION")...

Hi, I have some data with start and end dates, and I need to build some VBA to duplicate lines so there are month-specific entries. Hopefully this example *might* explain it :) If the raw data looks like this: <b>Name___Start Date___End Date</b> Person1__01/01/2019___31/03/2019...

Hi I have a spreadsheet which contains mutiple different rows I want to duplicate all the rows multiple times using a value in the duplicate colum The Kick Off Date contains the formula =DATE(YEAR(G2),MONTH(G2),DAY(G2)+F2) and End Date contain the formula =DATE(YEAR(C2),MONTH(C2),DAY(C2)+D2)...

Hello Excel VBA Masters, I'm hoping someone can help me with my current challenge. I hope to cycle through a one dimension array and when a duplicate piece of data is found the first instance of a duplicate has "dupe_1" appended to the data. If a second duplicate is found it will have "dupe_2"...

Hello I am fairly new to VBA and i am looking to create a tabel without having someone enter duplicate records over and over by hitting the AddReturn button over and over. below is what i am using for the command button. Any Idead what i should add to stop this? Private Sub AddReturn_Click()...

https://www.dropbox.com/s/j14abilgo2yyphu/Test.xlsm?dl=0Hi, I am working on one huge file. where I have duplicate person name in col. B. I am looking for a code which highlight these names if same person has same deptt and same PO issue date. Like person we have three ZZZ person name but...

I have six separate sheets that follow the same structure as the table below. In each sheet, I want the first column to remain the exact same. So if I start adding/removing columns from the first sheet, I want the following five sheets to automatically duplicate. Anyone have something that...

Hello, I have done a fair bit of research with no luck and hoping to get some assistance. I have data from A3 to W10,000 and I am looking for a macro that can remove rows where the name in column C is a duplicate and the date in column W is within 21 days of another date with the duplicated...

Del Duplicate Row if Col A, B, C matched I had thousand row, so possible to use macro?

Hello smart people, I have a large spreadsheet i'm using for people's names/addresses/phone numbers etc I have to add more constantly when a new download becomes available. However, on my initial sheet I fill the row (example, they don't want to be contacted is red, left a message yellow) I...