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.

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

But again, both D and E data need to match.

thanks in advance.
Chris

Hi Chris,

Please share a sample sheet.. thanks.


Regards,
DILIPandey
<click on below * if this helps>

hi Chris, maybe:
=IF(SUMPRODUCT((D$2:D2=D2)*(E$2:E2=E2))>1,2,1)

or in Excel 2007 & above:
=IF(COUNTIFS(D$2:D2,D2,E$2:E2,E2)>1,2,1)