+ Reply to Thread
Results 1 to 2 of 2

Question: Count Unique/Duplicated 5 number Combination

  1. #1
    Forum Contributor
    Join Date
    10-21-2012
    Location
    miami, florida usa
    MS-Off Ver
    Excel 2007
    Posts
    260

    Question: Count Unique/Duplicated 5 number Combination

    Hi Guys,

    I have read multiple threads,Searched videos for this issue, and I haven't seem nothing to apply the solution to my spreadsheet.


    this is what i got :
    1-.range of 5 Numbers Combination,
    2-.each number is using single Cell,
    3-.Many of the combination are Duplicated

    Already applied The Find Uniques/Duplicates with conditional Format.


    Please I need to know (Either) a Function that Count Unique/Duplicated Combinations

    OR

    I need to know a Function that Extract Unique Combinations



    Col--> R S T U V

    R:8--> 11 13 22 31 33 <--Duplicated
    R:9--> 01 08 10 15 28
    R:10-> 02 04 06 17 31
    R:11-> 01 08 10 28 30
    R:12-> 11 16 22 28 34
    R:13-> 02 04 06 26 31 <--Duplicated
    R:14-> 02 04 06 26 31 <--Duplicated
    R:15-> 01 10 15 27 32
    R:16-> 04 12 13 22 29
    R:17-> 06 07 19 25 26
    R:18-> 05 07 12 13 22
    R:19-> 06 19 25 26 34 <--Duplicated
    R:20-> 06 19 25 26 34 <--Duplicated
    R:21-> 11 13 22 31 33 <--Duplicated


    Thank you !

  2. #2
    Forum Contributor
    Join Date
    10-21-2012
    Location
    miami, florida usa
    MS-Off Ver
    Excel 2007
    Posts
    260

    Re: Question: Count Unique/Duplicated 5 number Combination

    Hello,

    I Forgot to Mention that I Try it to Highlight the Duplicated Combination with Conditional Format and won't work

    might because I Applied Search and Highlight the same Cell range with countif Function through conditional format??


    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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