Comments on: How to find duplicates in Excel: identify, highlight, count, filter

The tutorial explains how to search for duplicates in Excel. You will learn a few formulas to identify duplicate values or find duplicate rows with or without first occurrences. You will also learn how to count instances of each duplicate record individually and find the total number of dupes in a column, how to filter duplicates, and more. Continue reading →

Comments page 2. Total comments: 262

  1. I'm working on Excel spreed sheet of 120,000 rows with 6 columns. There are many duplicates that I don't want to delete. Rather, I want to re-edit the duplicate to make them unique.

    Please, which formula can I use to extract these duplicates and edit them?

    Thank you.

    1. Hi!
      Read the paragraph above - How to filter duplicates in Excel.
      To highlight duplicate values in a column or range, you can use Excel Conditional Formatting. Read this guide.
      You can also use the Duplicate Remover to quickly find and copy duplicates to a separate sheet.

  2. Can you use an extended Countif function to count the number of rows between the 1st same cell value and the 2nd same cell value in a given row, of, say, a known row count value?
    A1. 1
    A2. 2
    A3. 5
    A4. 6
    A5. 1
    The value I would need is Cell A5 - Cell A1 = 4, since I am looking for duplicate values of 1.
    Thanks.

  3. I have a list of over 2000 names and want to find out if there are any that have at least one duplicate but I only want the first duplicate reported.

    For Example: if I have a list of last names that includes: Smith, Jones, Jackson, Johnson, Cottrill, Fee, Jackson, Zant, Zenner, Jones, Fee, Jackson, Jones, Smith, Sbory, Smith

    I want the report to tell me that I have 3 duplicates not 9 (So only counting the first time it hits a duplicate and ignore the rest)

    What is that formula?

    Thank you!

    1. Hello!
      Get a list of duplicates as described in the article above and apply the UNIQUE function.
      Please check the formula below, it should work for you:

      =COUNTA(UNIQUE(FILTER(A1:A20,COUNTIF(A1:A20,A1:A20)>1,"")))

    2. So in further reading of this I think what I am trying to find out is how to count only the 2nd occurrence of the piece of data within a range.

  4. I have a table A1 Date , B1 Spare parts, C1 P/N,D1 S/N, E1 Total Hours, and sometimes the column P/N duplicate in different dates and total hours, for example at 1/7/22 P/N SHR123 has been installed at total hours 45822:35 and the same P/N installed at 25/7/22 at total time 45970:15 then i want to calculate the two different total times between two dates.

      1. thank you sir, I'll clear my question.... I working at Airlines Co. and I'm following the aircraft's hours and spare parts, so i have a table consists of Columns (A, B, C, D, E,) its titles are: (Date , Spare parts, P/N, S/N, and Total Hours), and sometimes the P/N of any spare parts is duplicate at a different dates and total hours, for example at 1/7/22 P/N SHR123 has been installed at total hours 45822:35 and the same P/N installed at 25/7/22 at total time 45970:15 then I want to calculate the two different total times between two dates

        1. Hi!
          I am not sure I fully understand what you mean. What does the phrase "two different total times between two dates" mean? What result do you want to get from your data?

          1. I'm sorry sir i mean subtract (minus) between tow total hours 45822:35 & 45970:15 which the spare part P/N SHR123 has been installed at a different dates 1/7/22 & 25/7/22.

            Note: sometimes the P/N install and remove and install again so, i find duplicate more than twice with a different hours and different dates, then i want to subtract between the first install and the second install by minus the two total hours for the same duplicate P/N.

            1. Hi!
              Convert the text 45822:35 & 45970:15 to a date and time as I recommended earlier. Then calculate the date difference between these two numbers (in days, hours and minutes).
              To calculate in hours, use this formula -

              =LEFT(E1,SEARCH(":",E1)-1)+RIGHT(E1,2)/60

              1. Thanks Sir, let me ask another question ......
                How can I subtract two cells in a column depending on duplicate cell in another column?

  5. I have multiple sheets. On sheet 1, I have a list of names in column D. If the name is coming up for the first time in column D, I need column E to say Yes. If column D is not the first occurrence, I need column E to say N/A. Then, sheet 2 needs to check if there are duplicates in the previous sheet. If the name shows up in the previous sheet, column E should say N/A. If it's the first occurrence, column E will say yes. Sheet 3 will check sheet 1 and 2, same rules apply. If there a formula I can use for that?

  6. Hello,

    I am preparing my salary file in Excel and we have different sites and locations. Employees are often transferred from one location to another. We have 2 modes of payment - 1 official through payroll and some part as cash incentive for job completed.

    The accountant many a times forgets to delete the name from one location when he is transferred to some other site wherein he adds him again, this results in duplication of payment.

    Can you please help me the way to find out on how to check whether one particular person is not there in any other site.

    Will be waiting to hear a fruitful reply on the above

  7. Hello and thank you for your helpful tutorial.

    I have column A with duplicate data.
    To copy column A to B and leave the first occurrence
    I have entered the formula =IF(COUNTIF($C1:$C$7, $C1)>1, "", A1)
    Column C has various unique texts
    With this formula all occurrences appearing at the last row e.g: 280 at row 3 and 150 at row 7
    How do I get them at the first row e.g: 280 in row 1 and 150 at row 4?
    I have tried to change the >1 to 0 and <0 but it doesn't work
    I am using excel 2003
    Hereunder The result I get

    A B C
    1. 280 Red
    2. 280 Red
    3. 280 280 Red
    4. 150 Green
    5. 150 Green
    6. 150 Green
    7. 150 150 Green

    Regards

  8. Hi Alex!

    Thank you for sharing all of this formula. it is very helpfull. i got some question;

    how to count the total of duplicate item? for example;

    i know that there is a total of 4 duplicate bananas, 3 duplicate orange, 6 duplicate grapes & so on.. but how do i calculate how many fruits that has duplicate quantity?

    Thank you in advance!

    1. Hello!
      I think that your problem cannot be solved with a single formula. If column A contains items, column B contains the number of duplicates, then try the formula:

      =IFERROR(ROWS(UNIQUE(FILTER(A2:A10,B2:B10>1))), 0)

      Try to use the recommendations described in this article: Count unique values with criteria.
      I hope I answered your question. If something is still unclear, please feel free to ask.

  9. I have a starting 6-digit sequence # in cell L2 and an ending 6 digit sequence # in cell M2. These represent ranges of sequence numbers. They could be a few hundred to a hundred thousand. L2 would be a specified job, L3 another and so forth, each job with unique sequence numbers. These ranges of sequence numbers go on through L40 and M40. I want to make sure that nothing in any of these ranges of numbers are duplicates.

    Right now I have =COUNTIF($L$2:$M$35,L2)>1 but this only recognizes the actual printed number and not the numbers that are hidden in the range. 748375(L2) to 749927(M2) for example. If another line contains 749926, that is an encroachment and should be flagged as a duplicate.

  10. Finally a clear listed formulas!

    I have already located duplicated cells with conditional formatting into highlighted cells.

    But which formula / method would work the best for finding duplicate values (names) across few rows, I was comparing two name lists which I have stripped every word into single cells.

    I I'd love to try one by one but it loads for so long every time I input anything.

    Thanks in advance!

  11. I have massive amounts of data in columns B and columns C. column B is lists of names and column c is just a location number like "1234" and that's it. I need a formula to filter out how many times column b and c duplicate and it to show me exactly who is duplicated and how many times.

    1. Hello!
      How to identify duplicate rows and how to count duplicates, you can read in this article above. Have you tried these recommendations? If this is not what you wanted, please describe the problem in more detail.

  12. Hello,
    I have several files in pdf and i would like to cross check using excel if there are duplicate refs. Is there any formula for it?

  13. HI.
    I want to compare two rows of number,find duplicate,but not triple numbers,only two same numbers,not more.
    please help.

    1. Hi!
      If I understand your task correctly, try the following formula from the first paragraph:

      =COUNTIF(A:A, A2)=2

      I hope it’ll be helpful.

  14. Hi,
    A condition, my each column has
    A1- Apple, B1- Apple, C1- Orange.
    A2- Mango, B2- Apple, C2- Mango.
    And so on, now I want in D1 and D2
    only single fruit names with “/“ as its separator.

    Pls help.

  15. Anyone have any idea how to highlight duplicates within the column itself across the entire sheet? Meaning to say the conditional formatting ignores duplicated between columns and just checks for duplicates within the column itself?

  16. Hello, I have a spreadsheet where I record sales for each day. So 29/11/2021 may contain =SUM:(M104, M108, M121) and then 30/11/2021 may contain =SUM:(M105, M107, M121). The "M121" is a duplicate in these formulas. Is there any way to find and delete these duplicates. Thanks

  17. Hello,
    I'm not sure if this is the right post to make this question but... I was trying to make the collatz conjecture on excel and I was trying to find a formula that: if in any previous column a number has appeared or any of it's multiples by 2^n (example: if I have put the number 1 then with the collatz conjecture I would get a 1-4-2-1 so the next number to add would be a 3 because the 2 has already appeared on a previous column, then I would get a 3-10-5-16-8-4-2-1-4-2-1 (possibly would have ended up in 16 due to the number being 1*2^4) and the next number to appear would be number 7 because 6 is 3*2^1 and so forth) do we have any command on excel that allows us to simplify this problem and how would you do this?

  18. Hi Alexander,

    How do I compare 3 sheets for duplicates and highlight them? (the 3 sheets is in the same workbook).

    For example, I want to check if Sheet1 A1:A5 have duplicates from Sheet2 A1:A5 and Sheet3 A1:A5?

    Alexander , thank you very much.

  19. I want to create a condititional formula to highlight the duplicate values in a column. And then I want to copy that formula to different/multiple columns on the same and diff sheets.
    2nd, when I type a question mark (?), then excel treats it as a duplicate, even when there is no duplicate ? in that column.

    Kindly help.

  20. How can i find the duplicate cell in different rows and multiple column?
    and delete them?

  21. Hello,

    Can you help me with my problem?
    How to remove duplicates in different column?

    original data It's like this:

    1 1 5 5 5 3 4 4

    and turn to this:

    1 5 3 4

    Remove the duplicates but retain the 1st one.

    Thank you in advance.

    1. Hello!
      All duplicate detection methods require data to be arranged vertically in columns. Therefore, first, transpose the data as described in this guide. Then remove the duplicates. For detailed instructions, see this article. Then transpose the data again.

  22. Thank you so much this was such a huge help!

  23. Hello Alex!
    i just want to know how do I command a duplicate cell to join to different cells into one

    Example;
    Column A Column B Column C (where a+b)
    Apple Fruit Apple Fruit + Red
    Apple Red
    Banana Yellow Banana Yellow

  24. How do i separate the duplicate numbers/codes from each other in one excel sheet? sample below?

    1)
    1759DD447361
    1759DD447361
    1759DD447369
    1759DD447369
    1759DD447381
    1759DD447381

    2)
    1759DD447361
    1759DD447369
    1759DD447381

    1759DD447361
    1759DD447369
    1759DD447381

    1. Hi!
      What does "separate the duplicate" mean? Have you tried the ways described in this blog post? If they don’t work for you, then please describe your task in detail, I’ll try to suggest a solution.

      1. Thank you Alex!
        In my previous comment, there are two items. Item 1) has all the records, while item 2) the duplicates have been separated on same excel sheet. How can i achieve that and still keep both records in same sheet?

          1. Thanks

  25. This is great! However, I'm thinking of multiplying a certain no. or cell using if function for duplicates. Say if k3 cell duplicates within k1:k6, e3*85%, otherwise e3=100%.

    Tried using this --> [=another formula*(if(countif(k1:k6,k3)>1,e3*0.85,e3*1)] but sadly errors.

    Would anyone know how to go about this? Thanks in advance!

    1. Hello!
      This formula works for me.

      =(A3+A4)*IF(COUNTIF(K1:K6,K3)>1,E3*0.85,E3*1)

      If you get an error, please describe the problem in more detail.

      1. You're Godsent. Got why it errors. I doubled the multiplication in the formula. Thanks so much! :)

  26. how can we identify the duplicate location/reference designators in the different rows?

    Example
    1:-
    R1 Duplicate in both.

    R1.

    R1,R11,R12,R35,R187,R196,R203,R220,R221,R230,R231,R232,R233,R245,R246,R272,R283,R292,R297,R303,R321,R322,R342,R343,R345,R346,R349,R386,R406,R409,R532,R544,R555,R811,R812,R1033,R1034,R1035,R1036,R1779..

    2:-
    R4 Duplicate in Both.

    R4,R6.

    R2,R3,R4,R5.

    3:-
    R5 Duplicate in Both.

    R2,R3,R4,R5.

    R5,R46,R47,R48,R49,R54,R58,R60,R61,R65,R75,R82,R83,R84,R85,R86,R87,R184,R189,R190,R191,R192,R193,R238,R239,R240,R241,R258,R265,R266,R267,R268,R275,R276,R277,R278,R286,R287,R288,R289,R293,R294,R295,R296,R298,R299,R301,R331,R332,R333,R334,R335,R336,R337,R338,R339,R341,R344,R351,R352,R353,R354,R355,R356,R357,R358,R705,R867,R921,R924,R977,R978,R980,R981,R1038,R1052,R1053,R1767,R1768,R1769,R1772,R1784,R1785,R1786.

    1. Hello!
      Split each cell. Use a comma as a separator. To do this, you can use the Split Text tool. Use Duplicate Remover - Find Duplicate Cells tool to find duplicates. It is available as a part of our Ultimate Suite for Excel that you can install in a trial mode and check how it works for free.
      If something is still unclear, please feel free to ask.

  27. Using a formula(s), is there a way to find duplicate rows with multiple columns but info in columns are not necessarily in the same order.where the examples below are considered duplicates even if they're not in order?
    A B C D
    LAX SFO ATL DUPLICATE
    PDX ATL LAX
    LAS ATL LAX
    JAX LAX PDX
    SFO ATL LAX DUPLICATE
    JAX LAS MCI

  28. Hello,
    First, great tutorial, very useful. I applied some of the formulas to solve a situation. I just needed to know if the data I load into an Excel table is duplicated, I don't need to know which rows are repeated, just to know the data is wrong so I can go to source to solve a problem I didn't know existed. The approach of the array formula that does not require a helper column seems the best option:
    =ROWS($A$2:$A$8)-SUM(IF( COUNTIFS($A$2:$A$8,$A$2:$A$8, $B$2:$B$8,$B$2:$B$8)=1,1,0))
    But then I came across a situation. Sometimes one of the columns can have a blank value, when that happens the formula identifies that row as not unique and returns a wrong value. I could fix the situation with this formula:
    =ROWS($A$2:$A$8)- SUM(--( COUNTIFS($A$2:$A$8,$A$2:$A$8, $B$2:$B$8,choose({1,2},$B$2:$B$8,""))=1))
    As you can see, I added the "choose" function with {1,2} as the index num so the "Choose" function returns both, the complete range that is used as criteria plus the empty space value "" counting correctly the blank cells when needed.
    Another change I did was the use of "--" instead of the "if" function, but that doesn't change the result.

    1. Hi,

      I have 1500 lines data, I have to identify the duplicate with B collom and C collom,if that should match cell details and C cell details,how can I apply the formula for identifying the duplicate with same details matching with more than one.

      1. Hi! It's hard to tell exactly what you're asking for as it's currently written. Pay attention to the following paragraph of the article above: How to find duplicate rows in Excel. Or explain your problem in more detail.

  29. Dear Sir/Madam,

    Is there a way to find duplicate values in a single cell in MS-Excel? I'm working on a CSV file where there are duplicate values occurring in a single cell only. Can you please help?

  30. How to find last 4 digit duplicate value and marked. is there any formula. e.g.
    JVC2020TDL2946
    BV2020TDL2946
    JVC2020TDL2947
    BV2020TDL2947
    JV2020TDL0224
    JV2020TDL0225

    1. Hello!
      You can extract the last 4 digits into a separate column using the RIGHT function. Then look for duplicates in that column as described in the tutorial above.
      I hope this will help, otherwise please do not hesitate to contact me anytime.

      1. Thanks Sir
        for your reply and i have also tried this option it will work properly.

  31. I know that this is old but the easiest solution would be to highlight a column, go to conditional formatting->highlight cell rules, then duplicates. After that, just filter by color.
    To rmove them, there is a built in button in excel, under the data tab.

  32. How to choose repeated number example for this case:
    12344445678910444. The correct answer is 4

  33. Hi, I need to modify the formula that extracts ONLY duplicates from column to make it able to work from the first row.
    =IFERROR(INDEX(A$2:A$16,MATCH(1,COUNTIF($A$1:A1,A$2:A$16)=0)*COUNTIF(A$2:A$16,A$2:A$16)>=2)),0)),"")
    As you can see it doesn't allow to be placed in the first row due to cell reference problem in this part COUNTIF($A$1:A1,A$2:A$16).

    Is there any alternative option?

  34. Hi
    I hope you are doing very well.

    Your solutions are very helpful.

    Thanks a lot.

  35. hi, how to find duplicate from 2 sheets and highlight with color

    1. Hello!
      All the recommendations you need are listed in the article above. Make external references to another sheets of your workbook correctly as described in this guide.

  36. I am trying to count how many duplicate names are found in Col A. I have 600 plus rows and I just want the count each time I find a duplicate value. I tried

    Column B
    =COUNTIF($A$2:$A$800, $A2)

    Column C
    =IF(COUNTIF($A$2:$A$800, $A2)>1, "Duplicate", "Unique")

    But I only return 722 value in Column, and only Duplicate in Column C (used to remove Duplicate, just leave one count total.)

    Im looking for:
    Appels 121
    Grapes 253
    Bananas 10
    Oranges 400

    Is this possible? Any kind help?

    1. Hi,
      I don't really understand what you want to find. To remove duplicates, it is best to use a formula that ignores the first occurrence of the value. See "How to search for duplicates in Excel without 1st occurrences". To remove duplicates, I recommend using Duplicate Remover Toolkit for Excel. It is available as a part of our Ultimate Suite for Excel that you can install in a trial mode and check how it works for free.
      If this is not what you want, please describe the problem in more detail. I will try to help.

  37. Hi,

    I would need some help regarding this issues:
    1. I have a list with names, I had found the duplicates. My task is: Using a single formula, detect all of the duplicates in the above list. If the term has already appeared in the list, then your formula should display it on the same row, if the term has not already appeared on the list then your formula should display N/A.

    Name
    Cristina
    Ioana
    Florin
    George
    Cristina
    Cosmin
    Neculai
    Alina
    Florentina
    Andreea
    Laura
    Alina

    2. I need a formula for completing this task: Create a formula that returns only the characters that appear after "X" for the given character strings. The same formula must work for the whole column!
    Example: 45629X421 421

    1. Hello!
      I hope you have studied the recommendations in the tutorial above. It contains answers to your question.
      To return all characters after "X" use the formula

      =MID(B1,SEARCH("X",B1,1)+1,100)

      I hope it’ll be helpful.

    2. I found the formula for task 2.
      Any thoughts for the 1st task?

      Thanks!

  38. How do i get collegue names if website duplicates. Let say first 3 people are at same company (same website) So i need to get collegue name such as

    Sam - Nick
    Nick - David
    David - Sam

    How do i get them.

    Full Name Collegue Name Website
    Sam abc.com
    Nick abc.com
    David abc.com
    Peter 123.com
    Ann 123.com

    1. Hello!
      If I understand your task correctly, the following formula should work for you:

      {=IFERROR(INDEX($B$2:$B$12, SMALL(IF($D2=$A$2:$A$12, ROW($B$2:$B$12)-1,""), COLUMN()-4)),"")}

      This is an array formula and it needs to be entered via Ctrl + Shift + Enter, not just Enter. Line 1 is the title of the table. Column A is a list of websites. Column B is a list of names. Column D is the website where you want to find the names of colleagues.
      You can read more about this formula in the article: How to VLOOKUP multiple values in Excel
      You can combine names in one cell with delimiters using the formula

      =TEXTJOIN("-",TRUE,J2:N2)

      I hope my advice will help you solve your task. If something is still unclear, please feel free to ask.

  39. Hello,
    sorry, how to find the last duplicate value in row ,
    such as:
    A B C D
    2 4 3 2

    i want to find the number "2" that is from column "D"
    tnx..

    1. Hello!
      If I understand your task correctly, the following formula should work for you:

      =IFERROR(INDEX((IF(COUNTIF(A1:F1,A1:F1)>1,A1:F1,"")),,MATCH(TRUE,(IF(COUNTIF(A1:F1,A1:F1)>1,A1:F1,""))<>"",0)),"")

      I hope I answered your question. If something is still unclear, please feel free to ask.

  40. extremely killer tricks.... Brilliant.... Many wishes for you and best of luck...

  41. how can I set formula to move any duplicates document id to next 3 columns in excel? thanks

    document id: 1st allocation id 2nd allocation id 3rd allocation ID
    12345
    23456
    12356
    11236
    23456
    23562
    89712
    12345
    12346
    12356

    1. Hello!
      Sorry, it's not quite clear what you are trying to achieve. I don't see any pattern in your numbers. Could you please describe it in more detail? What result do you want to get?

  42. I am creating a quiz bank. I want to find duplicates within a row and then be able to copy the formula down a column. I tried using the formula =IF(COUNTIF(C1:I1,), "duplicate", ""). However it only returns duplicates of the first cell. I need to know if ANY of the cells in that row are duplicates. Please help!

    1. Hello!
      If I got you right, the formula below will help you with your task:

      =IF(SUM(--(COUNTIF(C1:I1,C1:I1)>1)) > 0,"duplicate","")

      After that, you can copy this formula down along the column.
      I hope it’ll be helpful.

      1. It works perfectly! Thank you SOOOOOOOO much!

    2. Sorry I just realized the formula i put in above is not the formula I am using. It is =if(countif(C1:I1,C1)>1 "duplicate", "")

  43. If the range is not continious, example A1:A5 and B1:B15 then how to check if the 15 values in these cells have duplicate or not

  44. Hey
    How to paste data in a merge cell
    Help me if u know

    1. Hello!
      I’m sorry but your task is not entirely clear to me.
      Please describe your problem in more detail. Write an example of the source data and the result you want to get. It’ll help me understand it better and find a solution for you. Thank you.

  45. Quick Question, Is there a way to set the 1st row of duplicate records to "Parent"
    I am using this formula: =IF(COUNTIFS($A$2:$A,A2,$B$2:$B,B2,$C$2:$C,C2)>1,"Child","Parent")
    Row 1 - Parent
    Row 2 - Child
    Row 3 - Child
    instead of
    Row 1 - Child
    Row 2 - Child
    Row 3 - Child
    Help is greatly appreciated.

    1. Hello!
      If I understand your task correctly, you need to set the first occurrence of a duplicate as Parent" marking the rest of them as "Child".
      Assuming that your table has no header, here is the right formula for you:

      =IF(COUNTIF(A1:$A$26,A1)>1, IF(AND(COUNTIF(A1:$A$26,A1)>1, MATCH(A1,$A$1:$A$26,0)=ROW(A1)), "Parent","Child"),"")

      If however, there is a 1-line header, the formula should be modified a little to look like the one below:

      =IF(COUNTIF(A2:$A$27,A2)>1, IF(AND(COUNTIF(A2:$A$27,A2)>1, MATCH(A2,$A$2:$A$27,0)=ROW(A2)-1), "Parent","Child"),"")

      Hope this is exactly what you need.

  46. ok I have an excel worksheet that I want to add a formula to catch duplicates throughout the worksheet. I don't want the 1st selected column ex:A2 to change I want it to carry down to where it catches any above it, Say I am on row A 15 I want it to look at rows A2-A14 to make sure the information I added in A15 wasn't on any above it. Can you help with this please?

  47. Good Afternoon!
    I have a workbook spreadsheet (SP1) that is pulling data from another workbook spreadsheet (SP2) using an if statement formula. In SP2, column A, I'm pulling data from SP1, column G. I would like to highlight the row in SP2 if a duplicate is found in column A. However, I'm not sure if I can do that with there already being a formula in each cell.
    To better clarify my question - Is there a way to highlight a row when the data pulled in column A duplicates, and to not highlight if no data is pulled or the result is "false".

    My issue right now is that because there is a formula in every cell when I use conditional formatting it ends up highlighting the entire workbook. I only want it to highlight if column A shows a duplicate result (A1 formula result shows: a, A5 formula result shows: a).

  48. Thanks, Svetlana
    It was awesome.

  49. Is there a way to find the exact location (using Index and Match) next to the first, second (and so on) duplicate value? Suppose Mary 100 and Donald 100 in a long list of names in column A and values in column B. Would it be possible using Index/Match to put "Mary" and "Donald" in the same order in Column C?

  50. Hi,
    I need to flag 1st duplicate and 2nd duplicate till nth duplicate with respect to date.
    for ex: 01/01/2010 is having data with duplicates and using COUNTIF it can return 1st duplicate and then 02/01/2020 is having same data and I need to flag second duplicate vice versa.

    I am using below formula
    "{=IF(COUNTIF($A$3:A3,A3)>1,"NX","X")}
    here "X" return with 1st duplicate value

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)