duplication

The image shows an ActiveX Combo Box On clickin the drop down the button does not present the linked list, instead it presents another drop down button inside the list area which when clicked presents the list required. Not all persons in my team have the issue. Changeing the combo box...

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

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

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

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

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

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

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

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

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.

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

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

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?

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

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

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

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

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

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

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