duplication

  1. M

    vba excel

    hello everyone, I have a question regarding vba if I move a data from file a to file b when pressing f8 the process repeats thus in file b there will be a duplication what can I do to remove duplication using the vba of file a waiting for a reply asap thank you
  2. L

    duplicate an x amount of rows but with each duplication increment by 1 all the numerical values within the row

    Hi, I have the following problem and not sure how to go about doing this. I have the axample below" <colgroup><col style="mso-width-source:userset;mso-width-alt:2816;width:58pt" width="77"> <col style="mso-width-source:userset;mso-width-alt:3730;width:77pt" width="102"> </colgroup><tbody>...
  3. R

    Get First Data and Ignore for same PO

    Hi All - Need your expertise in excel :) Currently i have data with thousands of rows and there is duplication in some of data, but i can't delete it. i have column PO Number and duration of the PO (from PO created - PO release) and not in consecutive. In that column,I just want to take the...
  4. T

    Highlighting duplicates

    I am trying to highlight duplicates across two columns. So when a selection from column A and a selection from column B occur more than once together in the table, they are then highlighted. I can get it to work with duplicated entries from a single column, but not from both. So for example...
  5. A

    Identify Duplicates based on Name + DOB across columns

    Hope some1 can save me 3 months of work. I have a list 250 000 rows, of which some duplicates exists. I Need to identify the rows with duplicate names Column A - Contain Customer name (In a row, it may be Firstname Middle name Surname OR Surname Firstname Middle name) in some instances there...
  6. L

    preventing duplication

    Hi I know the formula to use to prevent duplication, thanks for your help. So I went to Data Validation->custome then wrote this formula = countif($a1:$a5,a1)=1 but did not fully understand it here is my understanding This formula will be apply on all the range =countif(range,a1) =1...
  7. S

    INDEX WITH TRANSPOSE FORMULA iIN EXCEL

    Hi, Column A2:A20 Contain with duplication text and the result should be appear in C2 without duplication. Any help much appreciated. <colgroup><col><col><col span="3"></colgroup><tbody> CODE RESULT 1515 1515 1616 1717 1515 1515 1515 1515 1616 1616...
  8. R

    Lookup/Array Formula

    Hi, Would anyone be able to help with the following? I've attached a screenshot for ease. My aim is to return the project codes 101 & 102 - this is because they have values against them in the three Q3 fields. Please note that I also want to avoid duplication ... so if there was two lines...
  9. A

    Prevent Duplication

    How do I create a formula that would show me if a number is used more than once in a column? I am not trying to create unique numbers I want any duplication of numbers to stand out.
  10. F

    Just start today learn VBA

    Hi I want to past a data to another file using macro without any duplication this below is past without considering any duplication Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ActiveWindow.Close savechanges:=True...
  11. A

    VBA code in 2 columns to allow for multiple pick list - but going acros all spreadsheet

    Hello I have added VBA code (thanks to this forum) to allow me to add multiple pick lists but I only want it in 2 columns but it appears to be adding the option (& thus duplication issues) across most columns. I have used the code below: Private Sub Worksheet_Change(ByVal Target As Range) Dim...
  12. L

    30 couples - dine out group

    I have 30 couples meeting each month for 7 months in groups of 3 couples(10 groups). How can they be arranged so they are always with different couples each month - no duplication?
  13. S

    CountIFs with multiple criteria and duplication

    Within a larger spreadsheet I have a Type (alpha, beta) column and Code 1 and Code 2 columns. Code columns are numeric from 1.1-7.9. I need to determine the number of alpha's who are coded 5.0-5.9 in either column without duplication. Some alphas are coded 5.0-5.9 in both columns but should...
  14. D

    Identify duplicates across rows and columns

    Hello, I have looked at other posts along these similar lines but I can't see anything that answers what I want. My data has the following columns: Column A = Surname Column B = Forename Column F = Date of last attendance Someone has very kindly chucked the data from several spreadsheets...
  15. S

    De-duplication across multiple columns using VBA

    Hi, I am new to VBA and have been trying to right some code that will automate the formatting of some semi-structured data. The big issue I have is with de-duplication. I am trying de duplicate data based on one column and merge additional columns onto one row. For example (simplified data)...
  16. M

    Help with removing duplicate data based on value

    Hi, I have a large amount of data that contains an inspection status of various types e.g D/1,D/2, D/3, RTN, TPR, there is also a cell which contains an inspection result of pass/fail. Each line of data refers to an item held in a database with a reference number. This data can have multiple...
  17. Y

    I am in need of the formula or VBA code to find the duplications.

    Hello Friends I work in on the task as i need to find out the duplications with the new data from the old data. For example If "AAAA" is in the column of old data. and the same "AAAA" would be in new data. when i compare the both i need the result in the adjacent column as "Genuine" if the new...
  18. S

    Comparison & Duplicate Check

    I have two columns with names of people, <TABLE style="WIDTH: 241pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=322><COLGROUP><COL style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 4352" width=119><COL style="WIDTH: 63pt; mso-width-source: userset...
  19. A

    Help needed...VLOOKUP - Unless a value has been seen before

    Hi all - thanks to anyone in advance who can help me with this question. I have a list which has been created using VLOOKUP... I need to create this list without duplicating any values.... e.g - My list: Column A Customer Advisors (Formula - =VLOOKUP(Z8,'Change Capacity...

Some videos you may like

This Week's Hot Topics

Top