duplicate

  1. P

    Deleting Rows with Duplicate Data in a User defined Column

    Greetings, Some days I amaze myself, other days I have trouble putting my socks on. This should be an easy macro to create, but I'm just not having any success. I want a macro for my (or someone else's) Personal.xlsb that will remove rows based on duplicate data in a column specified by the...
  2. A

    Restrict entering duplicate data in multiple column

    I want to restrict entering duplicate data in multiple column. <tbody> B C D F 20 Client Name Year Quarter Form Type 21 ABC 2017-18 Q1 26Q 22 XYZ 2017-18 Q1 26Q 23 ABC 2017-18 Q1 24Q 24 ABC 2017-18 Q1 26Q </tbody> From the above table we can see that Row no’s 21, 22 & 23 are...
  3. M

    finding duplicate names in 2 sheets

    Hi everyone, I have 2 separate sheet. Sheet 1 has Last Name, First Name in columns A & B respectively. On Sheet 2 I have First Name, Last Name in columns A & B respectively. Is there any easy way to check for duplicate first and last names between the two sheets? Thanks! Mark
  4. P

    Deleting Duplicate values

    Hi there, Im working with a data base which has so many duplicate entries. I need to the duplicates based on a condition. the condition is if the account (column b) is appears twice on the same day (column g) remove the record. I tried the data - delete duplicate records but it removed my...
  5. A

    VBA Userform Autofill

    Hi there, Would anyone be able to help? I am trying to create a code for my Userform to autofill certain textboxes based on the value of the initial textbox. The initial textbox that the code would be based on is Textbox_JobNumber. To explain in more detail there will be multiple duplicate...
  6. M

    find duplocates with multiple criteria

    <tbody> type amount flour 1g four 2g rice 5g veg 2g meat 1g </tbody> hello, I am still new to this forum and hope im asking in the right place. I have a table with duplicate in column B, and values In column a. I want to calculate how many duplicates I have in column b...
  7. B

    duplicate entries

    I have a formula: =vlookup (park!$R$1&BI3,rtzca,2) When I copy the formula down 10 rows, it will duplicate entries if rtzca had no more data to show. So, first 5 rows will be fine then rows 6-10 will show same exact data as row 5. Then I have to delete those duplicate rows. How do I stop that...
  8. K

    Dealing with Duplicate Data from Lists with Unique Values

    Hi, This question will probably be easy to some of you. Sheet A Column 1 - Unique Values Column 2 - Mixed Values some Duplicates some Unique I have a list of values I want to lookup in Column 2, my list has duplicate values, for each duplicate value in the List it relates to an entry in...
  9. R

    Pivot Table All Amounts Duplicated

    Hello, Could someone help me with a pivot table issue? I am having difficulties combining 3 tables together. I created a one to many relationship from table 1 to table 2 and table 3 as shown by the arrows in the below image. However, when I add a pivot table, all of the invoice numbers are...
  10. M

    Import file and scan for duplicates in column

    Dear Excel superusers, I´m an Excel newbie looking for help with this piece code I currently have this piece of code, that aggregates two Excel sheets by clicking on a button in my sheet and prevent using the same file twice: Option Explicit 'Aggregate different sheets Sub GetRisks() Dim...
  11. N

    Count Unique Duplicates

    Hi there, Glad to be here. Hoping someone could help with my issue. Scenario: Data table A is "dynamic". Each time a connection is refreshed, new data is inserted into column "A". What I'd like to be able to do is produce in column "E" for example, all duplicate values and then count the...
  12. A

    Index/Match/Max Tenure

    Good day I was trying to get a tenure using a specific value in array. The Formula I'm using works fine but I encounter issue when the criteria I was looking for has a duplicate in Row What I am trying to obtain is to get the tenure of an employee using the most recent data in a the array...
  13. D

    VBA to copy sheet to another workbook without locking the source?

    Afternoon all. I put a post up a few days ago about a way of doing this and have since decided that perhaps VBA is the way to go. https://www.mrexcel.com/forum/excel-questions/1062519-automatically-copy-entire-sheet-one-xls-another.html Anyway, a brief description of what i am looking to do...
  14. sharky12345

    Delete duplicate rows if values are identical across multiple columns

    I have a sheet with data across columns A:F - I'm trying to find a simple method using VBA to delete any duplicate rows, i.e. if there is more than 1 row with identical values across all columns then delete any row after the first. Can anyone help?
  15. G

    Duplicate Values for specific ranges

    Hello, I'm trying to remove duplicate values, however the problem is that by the usual conditional formatting method I will also delete duplicates I do not want to delete. The datasets is at follows: X, 100 X, 100 X, 100 Y, 200 Y, 200 Y, 200 Z, 100 Z, 100 Z, 100 And I want to get to X, 100...
  16. T

    Top 3 Users using INDEX/MATCH with duplicate values, but not duplicate names

    Hi all, I'm trying to figure out how to get the names of the Top 3 highest values without duplicating names, but allowing duplicate values. I have a list of (often repeating) names in table column [Last, First]. I have a single value relating to each name in table column [Used]. I have...
  17. K

    Find Duplicates

    I have Column A "Fist Name" and Column B "Last Name". For example <tbody> FIRST NAME LAST NAME Arpil & Pat Abernathy Pat Abernathy David Ackary David Ackary Karen Smith Bob Barker Ellen Barker Jack Smith David Brady </tbody> I want to highlight or indicate in a 3rd column...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top