Results 1 to 4 of 4

Counting only first occurance with two matching cells

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Counting only first occurance with two matching cells

    Hi all

    Looking for a match of data in cell d2 and E2, with a result only on the first occurance.
    it is almost a countif function, which i've used b4.
    =IF(COUNTIF(D$2:D2,D2)>1,1,0)
    Now that works for one reference, but I need a match for both cells before it produces the 0 and 1 outcomes.
    I have loads of data down the sheet, so it would need to be copied down the page for the 'ooo s of entries I have.

    If it works, I'd prefer the outcome as 1 and 2 respectively.
    =IF(COUNTIF(D$2:D2,D2)>1,2,1)
    But again, both D and E data need to match.

    thanks in advance.
    Chris
    Last edited by Christopherdj; 01-08-2013 at 02:36 AM.

Thread Information

Users Browsing this Thread

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

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