duplicate entries

  1. A

    VBA: Merging rows based on duplicate values in two columns

    I am trying to merge rows based on duplicate values in two columns. Specifically, look at the two screenshots below. If entries under Last Name (Column B) and Email (Column C) match in any two rows, then they should be merged. This is what it looks like originally: <tbody> First Name Last...
  2. B

    VBA preventing adding a name to a list if the name is already in the list

    I use the following code to enter a name selected from a listbox to the end of a list of names named "nameList" I please need some help to prevent the name being added if it already appears in the list and a messagebox to appear advising that the name was not added because it is already in the...
  3. F

    Newbie Question: Copying column entries if appearing in multiple columns

    Sorry for what is probably silly newbie question. I have a mailing list with 8000 email addresses, and I want to remove all email addresses who have not opened an email in last 8 newsletters sent to reduce to only those who actively read the email. I have column A containing 8000 email...
  4. C

    count the duplicate entries with the help of Macro

    Hi All, I want to Count the Duplicate entries in the column "SYMBOL" with the refeance of column "EXPIRY_DT" and also want to number them like... IF 31-Mar-16 than BANKNIFTY-I , 28-Apr-16 than BANKNIFTY-II & 26-MAY-16 than BANKNIFTY-III <tbody> INSTRUMENT "SYMBOL" "EXPIRY_DT" OPEN HIGH LOW...
  5. M

    Highlighting duplicates across rages of multiple sheets

    Hi Guys, I have a challenge which I am struggling with. I need to highlight duplicates in rages across multiple sheets in a workbook. There are 26 ranges which contain text values and the ranges are the same from sheets 1 to 10. Ranges are: D5:R5 D13:R13 D21:R21 D29:R29 D37:R37 D45:R45...
  6. W

    Flag several duplicate columns that occur within a 3 day range.

    Hi, I have the following named Ranges Activity ID Numeric, Unique --Key Field Customer Name Name Customer ID Numeric, Ticket ID Numeric ClosedDate1 Date AgentID1 FLast SCIP Event Yes / No What I am attempting to do, is Flag...
  7. A

    Stop duplicating entries when using a Macro to post dates from Excel into Outlook

    Hi, I am using the following macro to post dates from excel into outlook, however, each time I run the macro it duplicates the entry in Outlook. Any help on how to stop this would be greatly appreciated: Sub AddAppointments() ' Create the Outlook session Set myOutlook =...
  8. S

    Need help to eliminate duplicate numbers in a column with a VBA

    I was given a macro for this but it doesn't seem to work. Hopefully someone can help. column A will contain a list of telephone numbers entered in this format: (xxx) yyy-zzzz which is how it would appear in the formula bar if the cell were selected. I need a macro that would eliminate all...
  9. A

    Delete rows based on multiple columns

    Hi guys, I can't find a code that suits my needs, so I come to ask for your help. The basic idea I want to achieve is to have unique data in my sheet, but it's a bit more complicated then a basic RemoveDuplicates. There are some if's and but's I will try to explain as clear as I can. Col. A...
  10. H

    Return Less value based on Duplicate names

    Hello, I am looking for excel function to return less value in Duplicate names given below. Ex. if we take AAA has three duplicates with different values however, I need less value out of all the duplicates and should be return the less value as output, in this case value 100.00 should get as...
  11. L

    Remove duplicate values from countifs formula

    I have a very involved formula that counts data based on about 5 different criteria; however, the criteria is not defined by the name column. This is where the problem comes in. When I get the count of data that fulfills the criteria, there are a few anomaly items where the same person, in the...
  12. J

    Count Employees per Manager without duplicates

    Hello! I have some doubts about how to calculate this results. Without using a pivot table, I need to know how many employees each manager has. For example: If I enter the name: "Zara" on the cell G1 I'll need to get the number 5 on the cell H1, because Zara has 5 employees even though there...
  13. L

    Lookup duplicates and Delete Rows

    Hi, I have a database #1 of contact information consisting of e-mails, first name, last name, business name, etc. which contains many entries (rows) that need to be deleted. These entries would be deleted based on a secondary database #2 consisting of just e-mails. If there are duplicates...
  14. M

    Help counting duplicate values

    Hi, I have a large amount of data that contains a lot of duplicate records. The records can have different states but I just want to count the number of times a specific cell appears in the list of data, without removing duplicates. <TBODY> Tag?</SPAN> Insp. Date</SPAN> Insp. Time</SPAN>...
  15. J

    Identifying Consecutive Duplicates in long number strings

    I have identified potential fraud in a limited number of employees' time keeping postings and would like to figure out how to test if it is prevalent throughout the company. Here's the scenario: Looking at daily time sheet records I identified that certain employees had identical daily time...
  16. K

    How To Prevent Duplicate URL Entries in the Cell in a Column?

    Dear Experts, I tried to solve above problem using Data Validation formula but it does not help as per my wish. Because data validation does not work if somebody copy paste the duplicate values,it works when somebody types duplicate values in next column. So if I want to enter lot of urls to a...
  17. K

    COUNTIF for a column With Limits from a second column

    I'm a welding inspector trying to develop a weld tracking sheet and am in need of a formula that counts types of welds from column-B but without duplicating a weld number from Column A. For example: Weld#. weldType. Inspection. #ofwelds A. B...
  18. S

    Formula to Count Rows Meeting Multiple Criteria, Without Duplicates

    Greetings, This forum has served me well several times in the past while struggling with Excel, and I'm hoping you guys can come through for me now. No matter how much searching I do for this, the solutions provided to similar problems always boggle my mind a little too much for me to...
  19. S

    Identifying unique codes in a column and deleting sections of a row for all duplicates

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...
  20. P

    Find repeating values that occur only X times

    How can I specify the frequency / occurrence of repeating values that need to be found in a column or across different columns? For example, if a column had 1,2,3,3,4,4,4, I want Excel to only find values that repeat 3 times, and the answer should be 4. Someone gave a very good tip on how to...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top