+ Reply to Thread
Results 1 to 2 of 2

Extend count repated

  1. #1
    Registered User
    Join Date
    10-28-2008
    Location
    Portugal
    Posts
    1

    Extend count repated

    Hi. I have the following formula: countif($A$1$A:$9,$A$1:$A$9) and id counts the number of repeated cells the the range A1:A9. I need to extend this to work in two or more columns, that is, I want something like this: countif($A$1:$B$9,$A$1:$B$9) (result in C) but it doesn't work. But I need to count as pairs (a, b) and not just for each cell (see the illustration bellow).

    A B C
    ------------
    1 | a | b | 2 |
    ------------
    2 | a | c | 1 |
    ------------
    3 | a | b | 2 |
    ------------

    To better understand, please see the attachment.

    Thanks in advance,
    jacome
    Attached Files Attached Files

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Count instances of pairs

    In your posted workbook, try this
    Please Login or Register  to view this content.
    Copy that formula down through D8

    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

+ 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