A quick question...

Would you have used a helper column instead to concatenate Column A and
Column B, and then use ISNA(MATCH(...)) on the new column?

In article ,
Aladin Akyurek wrote:

Please forget my reply since I overlooked the concatenation bit in the
formula.

Domenic wrote:
It seems that on my version of Excel (Excel:Mac v.X) CSE is required.
Otherwise, the second IF statement is evaluated as FALSE and returns a
blank. Can you please confirm whether you get the same result?

In article ,
Aladin Akyurek wrote:


Domenic wrote:
[...]


D3, copied down:

=IF((A3<"")*(B3=C$2),IF(ISNA(MATCH(A3&B3,$A$1: A2&$B$1:B2,0)),LOOKUP(9.99
999999999999E+307,$D$2:D2)+1,""),"")

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.


[...]

Just ENTER will suffice.