Results 1 to 7 of 7

Count duplicate sets of 2 numbers

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-17-2020
    Location
    Uzbek
    MS-Off Ver
    Office 365, V 2212
    Posts
    198

    Post Count duplicate sets of 2 numbers

    Hi Experts,

    I have 7 numbers in columns A:G and would like to count how many duplicate sets of 2 numbers are there.

    For instance, the result of (2 0 2 6 1 0 2) should be 2 because there are only 2 same set of duplicates (02 & 02).

    Appreciate if someone could provide me a formula, I have attached the sample also for easy reference.

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to use SumProduct CountIf to count duplicate numbers as one?
    By DBrydon in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-27-2021, 06:54 AM
  2. Replies: 1
    Last Post: 04-22-2020, 02:45 PM
  3. MIN MAX using duplicate values across 3 sets of numbers
    By mrwiley in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-03-2019, 07:04 AM
  4. [SOLVED] Function to count duplicate or triplicate numbers occurrence in one cell
    By Karnik in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-19-2017, 11:04 PM
  5. [SOLVED] count non duplicate invoice numbers for a specific employee
    By bacardi510 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-26-2016, 04:31 PM
  6. Count duplicate numbers
    By sans in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-03-2011, 05:50 PM
  7. [SOLVED] How to count sets of numbers
    By JimDandy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-29-2006, 05:45 PM

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