Changing last instance based on multiple column match

[justinL]

Hello All,

I need to change the last instance of the "yes or no" column to be "yes" if the first two columns match. The prior matching instances would need to be "No".

Below are examples of the data before and after replacing based upon matching column data.


Incorrect:

18225	10	Yes
18225	20	Yes
18225	30	Yes
18225	30	Yes
18225	30	Yes
18225	50	Yes
19001	10	Yes
19001	10	No
19001	10	Yes
19001	10	No
19001	20	Yes
19001	20	No
19001	20	Yes
19001	20	Yes

<tbody>
</tbody>

would become if corrected:

18225 10 Yes 18225 20 Yes 18225 30 No 18225 30 No 18225 30 Yes 18225 50 Yes 19001 10 No 19001 10 No 19001 10 No 19001 10 Yes 19001 20 No 19001 20 No 19001 20 No 19001 20 Yes <tbody> </tbody>

<tbody>
</tbody>

My first time on the forum, bear with me and thanks in advance!

Justin

 

[DanteAmor]

Try this:

<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">18225</td><td style="text-align:right; ">10</td><td >Yes</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">18225</td><td style="text-align:right; ">20</td><td >Yes</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">18225</td><td style="text-align:right; ">30</td><td >No</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">18225</td><td style="text-align:right; ">30</td><td >No</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:right; ">18225</td><td style="text-align:right; ">30</td><td >Yes</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:right; ">18225</td><td style="text-align:right; ">50</td><td >Yes</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="text-align:right; ">19001</td><td style="text-align:right; ">10</td><td >No</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="text-align:right; ">19001</td><td style="text-align:right; ">10</td><td >No</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="text-align:right; ">19001</td><td style="text-align:right; ">10</td><td >No</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="text-align:right; ">19001</td><td style="text-align:right; ">10</td><td >Yes</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="text-align:right; ">19001</td><td style="text-align:right; ">20</td><td >No</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="text-align:right; ">19001</td><td style="text-align:right; ">20</td><td >No</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="text-align:right; ">19001</td><td style="text-align:right; ">20</td><td >No</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="text-align:right; ">19001</td><td style="text-align:right; ">20</td><td >Yes</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b></b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >C2</td><td >=IF(B2=B3,"No","Yes")</td></tr></table></td></tr></table> <br /><br />

 

[justinL]

Hi Dante,

That worked, looks like I was overthinking that one! I appreciate your help.

Thanks,

Justin

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.