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
Bookmarks