1. P

    Match Text string and Remove Duplicates

    I thank each and every Mr. Excel forum members who are helping hundreds of Productivity Issues daily. I am looking for a solution to remove similar duplicates by identifying the Pattern which every text ends with a Number. Based on Column A (primary key) - the macro should run on column B...
  2. S

    Find duplicates in column, then automatically deletes duplicates

    Hi All, I'm a beginner in terms of VBA and so I need help in finding duplicate data in columns then automatically deletes or selects them for deletion. Here's a macro VBA code I found on the internet but it only displays the word "duplicate" in another column. - Sub sbFindDuplicatesInColumn()...
  3. S

    VBA for finding duplicates values in a column and automatically selects it

    My problem here is there is already a VBA code for finding duplicates but the problem here is that. It still takes too much time to click all the duplicates 1 by 1 just to delete them, for example: Imagine a column filled with 5000 data and the duplicates found are around 1500, I can't possibly...
  4. ibmy

    Most number repetitive/duplicate occurring in SEQUENCE

    Hi, Can someone help me, sorry for bad English since it is not my native language here. Ok, I want to find what number in column show "most repetitive/duplicate in SEQUENCE". Im dealing about 100 000 data in a single column. Here what i have tried: (1) I tried use the "most frequently...
  5. L

    Formula to identify unique values from two columns

    Hello everyone, I am struggling to come up with a formula to find every unique value between two different columns. I would want it to identify a unique number only if it is unique between the two columns i.e if "5417" is in once on column A and once on Column B I am fine with that. That...
  6. D

    How to Check for Duplicates and Display a Count MsgBox

    I have Three worksheets, and essentially I want to select a cell in Column A of Sheet 2 (As the Active Cell) and check if there are any duplicates in Column A of Sheet 3 (The Range for this Sheet should be from A1 to the last row of Data). If there are any duplicates, I would like a msgbox to...
  7. R

    Automatically generate/separate duplicate value in cell.

    Hi guys, I need your help. I want to separate automatically the duplicate names in my list while typing them. I want to include also the quantity of duplicate names. The image "2" is only a sample which I would like to happen.
  8. J

    Formula help, counting unique occurences.

    I am looking for a formula that will count unique occurrences that start with W81UTH, ignoring duplicates and blank cells. Also looking for a formula that will count unique occurrences that does NOT start with W81UTH, ignoring duplicates and blank cells. I want to achieve the desired results...
  9. J

    Output first Match Found if Cells contain Duplicate Text

    Suppose I have several a range of cells, each cell of which contain a string, and I want a function to look at this range and output "FALSE" if all strings in the range are unique from each other and I want it to output the first duplicate it finds if there are at least two cells with the same...
  10. K

    Copy Duplicate Rows to a New Sheet

    Hi all, I am looking to copy duplicate rows from a large sheet of credit card charges. I want to copy any duplicate rows based on a string text in column "AL" on sheet "Trx List" to a sheet named "Duplicates". I'm really new to VBA so any help would be greatly appreciated! Thanks, K
  11. P

    Duplicate value search

    Can some one please provide a formula to allow me to identify duplicates within a specific range. I have a value in a cell H70 which is text that is selected from a drop down list. I want to know if that value has also in another cell (H4 for example). I would like the cell fill in H70 to go...
  12. I

    Delete Duplicate row based off of email then gender

    Hi all, I searched the forum and found 2 different macros that may work with some tweaking, but is beyond my capabilities. I need the following scenario to happen: 12000 email list has all info from first name, last name, address, gender, age, email and more. The only columns I am concerend...
  13. I

    Deleting columns if duplicate data found in a few

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

    Finding Only One Duplicate

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

    Summarize data with multiple criteria

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

    Removing duplicate Data

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

    Indicate First Duplicate Value in a Column when a condition exists in another column

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

    Advice on best method

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

    Column Duplicate and Search

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

    VBA to clear duplicate dates in column but keep row

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

Some videos you may like

This Week's Hot Topics