duplicates

  1. C

    VLOOKUP OR INDEX? Duplicate values exist, keep non-blank value (text & numbers)

    I have a very large spreadsheet that I am trying to return the value of some columns based on matching depths. Tab1 of my spreadsheet has no duplicate depths while Tab2 DOES have duplicate depths, some of which the columns have null values. The attached Example Tab1 image has a yellow...
  2. M

    Automatically run macro that highlights duplicates when user enters data into table.

    Hello. I use an excel document as a form where serial numbers are entered into a table (Table6). This table can not contain duplicate serial numbers. I added macro that highlights duplicates within the table but the user would have to run the macro after entering the data... and sometimes this...
  3. M

    Reading from a table in Excel

    Hello All, If anyone knows how I have a large data set and I would like to check there is duplicates. Issue is there are two parameters needed to confirm this. So for example I have in Cell B3 the Activity ID “BLH7895“ and in Cell C3 I have the Activity Name “Taking out the trash”. How would I...
  4. S

    Help with duplicates on Excel 2019 - Mac

    Hello, I am trying to compile a simple list of select student/ class scores derived from a master sheet that contains all the scores of all the students. So, the master sheet would contain the Following headers starting from Cell A1 - Student Name, Subject, Exam 1, Exam 2, Exam 3, Final...
  5. D

    Help with remove rows base on duplicate column value script

    The script below does a good work removing the rows based on the duplicates found in column a, however, it removes the last line with the duplicate, what I need is to remove the first line of the dups found. I appreciate your help. Column A Value 1 Value 2 <- Remove Value 2 Value 3<- Remove...
  6. A

    Cell Formula to count first occurrence of a customer name with criteria

    Hi! First time poster! I am trying to use a formula field to determine a first occurrence of a contract being signed ( ('Order Items'!$A:$A) result as a "1") or ending (('Order Items'!$B:$B) result as a "-1") per a client name ('Order Items'!$J:$J), per month ('Order Items'!$O:$O), to be...
  7. F

    Check duplicates in one column based on duplicates in another column and assign a value based on a condition.

    I have a few columns and couple thousand rows. Name Location Status Action Jake Germany out Retain Jake Ethiopia out Delete Jake Germany in Retain Jake Germany out Retain Jake Ethiopia out Delete In the above table, if Jake is "in" (3rd column) "Germany" (just an...
  8. D

    Remove duplicates in a row

    whats the best way to remove duplicate data in each column specifying a starting and ending column beginning sheet remove duplicates starting in row1 column J-P J K L M N O P 1 cat dog mouse cat 2 bat car ball switch car...
  9. I

    Duplicate data entries from dropdown menus

    Hello, I'm working on a personal project and I have the following problem: I have drop down menus in 13 rows of one column.. These dropdown menus have some overlapping values and some distinct values (on purpose). For example, Row 1 dropdown might have (1, 2, 3, 6, 7), Row 2 (2, 4, 5, 6), Row 3...
  10. U

    look for duplicates in the same column loop

    Hello, This might be a very simple solution but I just can't seem to get my head around it. Maybe one of you experts could help me out! :) I am looking to create a loop where the code looks for duplicates in one column (in this case, column A) and if it is a duplicate, the cell next to it...
  11. N

    How to separate duplicates into different files?

    I have a list of 2500 contacts with their respective email, I have duplicate contacts but the different email, I need to separate the duplicates in different excel files to not generate spam when I export it. What should I do?
  12. N

    Lookup Formula/VBA to find correct duplicate

    Hi there, I am looking for a formula/VBA solution that will lookup an ID in a separate list, then, if the ID appears in the list more than once, I want the formula to look at the date in the first list and find the ID in the 2nd list with the closest date match before returning the value in...
  13. Z

    How can I make cells, in a second worksheet, which are duplicate values of first worksheet, show in red?

    I have a worksheet which has a series of cells which contain data. The following month, the same cells, but some of them my show the same data, some may have changed. I would like to have those cells in the second worksheet that have NOT changed (in other words, the data is a duplicate of the...
  14. E

    Find duplicates in column, then insert row above duplicates

    Hello All, I have a table of data where in column C I have values that may repeat. I'd like to find the duplicate values and insert rows above each of them using vba. Any thoughts on how to do this? I've attached an image of a sample data set where the column of peoples names have duplicates. In...
  15. M

    Finding Duplicates across Multiple Tabs

    I'm trying to label rows as "Duplicate" in Column Q if i have a duplicate phone number in Column G across multiple tabs. I'm struggling with the formula. So far, I have: =IF(COUNTIFS($G$8:$G$2020, G8, 'FW 4'!$G$8:$G$2020, G8),>1,"Duplicated","") But it's not recognizing the second Criteria...
  16. D

    Condensing Column A to Remove Redundancies (Remove Duplicates and Consolidate doesn't do it)

    Hi! Thank you for reading this one. For an example of what I am trying to do, lets say I have a sheet that is about 200 rows long by 15 columns wide. It is one sheet with multiple bills-of-materials stacked one on top of the other. Column A has the master/parent numbers and Column B has all of...
  17. G

    Find Duplicates Across Range of Cells Within a Row

    I have a range of cells in a row I would like to check for text duplicates. See the image down below. I'm working with about 500 rows. I would love a formula to give me the result I have in cell G2. Sometimes a row may have no duplicates, 1 duplicate, 2 duplicates, 3 duplicates, etc. If that is...
  18. J

    Formula for counting

    I am trying to achieve the results in D3. I'm in need of a formula that will count unique names, ignoring the blanks and duplicates. Also ignoring the word "na" and "ns"
  19. J

    counting, ignoring multiple words and blanks

    I need formulas that will count unique occurrences, certain words while Ignoring blank cells and duplicates. I am trying to achieve the results in cells D8 and D9. In this case, I need to count occurrences that starts with W81UTH excluding duplicates and blank cells. I also need to count ALL...
  20. J

    Formula for Unique Occurence using multiple columns

    I am trying to achieved the desired results on E4. I'm looking for a formula that will count a unique occurrence specific to a date, ignoring duplicates and blanks. In this case, 19NOV19 has 2 trucks. 20NOV19 has 3 trucks. 21NOV19 has 2 trucks.

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top