Hello, firstly this is a follow up question to the below thread:
http://www.mrexcel.com/forum/excel-...nce-each-unique-value-column.html#post4143098
I was kindly give the following array formula to display Yes in column B for the last occurrence of each unique value in column A:
=REPT("Yes",ROWS($1:1)=MATCH(1,0/(A$1:A$9=A1)))
I would now like to achieve the same with but don't want to include rows where column C equals NA.
For example:
<tbody>
</tbody>
Hope this is explained clearly enough and appreciate any help you can offer.
http://www.mrexcel.com/forum/excel-...nce-each-unique-value-column.html#post4143098
I was kindly give the following array formula to display Yes in column B for the last occurrence of each unique value in column A:
=REPT("Yes",ROWS($1:1)=MATCH(1,0/(A$1:A$9=A1)))
I would now like to achieve the same with but don't want to include rows where column C equals NA.
For example:
A | B | C |
BN1 | ||
BN2 | ||
BN1 | ||
BN4 | Yes | |
BN3 | Yes | |
BN3 | NA | |
BN2 | Yes | |
BN1 | ||
BN1 | Yes |
<tbody>
</tbody>
Hope this is explained clearly enough and appreciate any help you can offer.