duplicate

Goal: If a duplicate value is found in a row, then delete the second the column associated with the duplicate value My problem: My code seems to work for the most part, except it only deletes the FIRST duplicate values that it finds, not all duplicate values. And if you run it again it seems to...

Hi everyone, I'm hoping one of you excel geniuses might be able to help me out.. I have a spreadsheet with data filled from F2 - F650. In that column there are some duplicates. In Column G I want to use a formula to identify only the duplicates and not the initial entry. So for example I...

Hi, I need help to summarize data as shown in picture. sum up duplicate invoices amount. Thanks [/URL][/IMG]

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