+ Reply to Thread
Results 1 to 8 of 8

Remove duplication in possible combination of 3 digits

  1. #1
    Registered User
    Join Date
    08-12-2020
    Location
    Pakistan
    MS-Off Ver
    2016
    Posts
    4

    Remove duplication in possible combination of 3 digits

    Hello Friends, i want to remove duplicates in combination generated for 3 digits in excel.
    I am uing
    Please Login or Register  to view this content.
    for possible combination of 3 digits.

    Please help, i am stuck now with duplicates.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Remove duplication in possible combination of 3 digits

    I don't see some manually calculated results in your file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    08-12-2020
    Location
    Pakistan
    MS-Off Ver
    2016
    Posts
    4

    Re: Remove duplication in possible combination of 3 digits

    Quote Originally Posted by oeldere View Post
    I don't see some manually calculated results in your file.
    Only Chosen No column is manually, rest of all are auto generated combinations for that chosen no. Or you can give me idea what to do for making 3 digits combinations without duplication.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Remove duplication in possible combination of 3 digits

    I have no idea what the result should be.

    In that case I can't provide a solution.

  5. #5
    Registered User
    Join Date
    08-12-2020
    Location
    Pakistan
    MS-Off Ver
    2016
    Posts
    4

    Re: Remove duplication in possible combination of 3 digits

    Quote Originally Posted by oeldere View Post
    I have no idea what the result should be.

    In that case I can't provide a solution.
    Try to view the attached sheet. Or you can suggest any other method for making combination of 3 digits without micros. Thanks

  6. #6
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Remove duplication in possible combination of 3 digits

    Hi
    See if this solution is good for you.
    Create a Helper column In O from O5 with this formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    This formula gives you the value 0 - no duplicates on that row, or value 1 - duplicates from column 4, or 2 - duplicates from column 2.
    See the file for clarification.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    08-12-2020
    Location
    Pakistan
    MS-Off Ver
    2016
    Posts
    4

    Re: Remove duplication in possible combination of 3 digits

    Quote Originally Posted by Josť Augusto View Post
    Hi
    See if this solution is good for you.
    Create a Helper column In O from O5 with this formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    This formula gives you the value 0 - no duplicates on that row, or value 1 - duplicates from column 4, or 2 - duplicates from column 2.
    See the file for clarification.
    Thanks Josť Augusto, its works. Bundle of thanks for your and other forum members who tried to solve it.

  8. #8
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Remove duplication in possible combination of 3 digits

    You are welcome.

    Don't forget to mark this thread s SOLVED.

    Thank you for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. I need duplication remove
    By sharaftali in forum Excel General
    Replies: 2
    Last Post: 10-11-2018, 01:21 AM
  2. Duplication remove with criteria
    By dwhite30518 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-23-2016, 10:23 PM
  3. Eliminating duplication combination of company/customer
    By Sanjay_ioc in forum Excel General
    Replies: 0
    Last Post: 07-30-2012, 09:11 AM
  4. DUPLICATION FOR COMBINATION OF 3 DISTINCT COLUMNS vba coding
    By rudhreswar kiran in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-20-2012, 03:06 AM
  5. how to remove first x digits and last y digits from a cell?
    By maixent in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-28-2009, 02:06 AM
  6. Every combination possible 0 and 1 on 9 digits
    By feejo in forum Excel General
    Replies: 2
    Last Post: 06-01-2008, 08:24 PM
  7. Remove duplication from validation list?
    By kk_oop@yahoo.com in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-16-2006, 10:20 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1