Try this in C2, which will involve both the invoice number and line code:
=IF(SUMPRODUCT(($A$2:$A$15=A2)*($B$2:$B$15=18))0, "A","B")
Copy down to return desired results. Success? hit YES below
--
Max
Singapore
---
"Mr. Low" wrote:
This only select the row with "18", not the the rest of the line with the
similar invoice number, eg, I need to select row 12 to row 15 as "A" when
only row 14 has the code "18". Any other solution ?