Grabbing Last Value of Column, but...

[rackem12]

As the title says there is more. I have some data (soccer scores). What I want to do is pull the date of the last game PLAYED by each team. I used to have a formula but I can not find it to the best of me.

							10/01/19 1.00 Tigre (ARG) San Martin Tucuman (ARG) 0 1 L W 10/02/19 1.00 Agropecuario (ARG) Deportivo Moron (ARG) 0 1 L W 10/03/19 1.00 Atletico Mitre (ARG) Barracas Central (ARG) 10/04/19 1.00 Flandria (ARG) Tristan Suarez (ARG) 10/04/19 1.00 Instituto Cordoba (ARG) Quilmes (ARG) 10/05/19 1.00 Almagro (ARG) Tigre (ARG) 10/05/19 1.00 Argentinos Jrs (ARG) Arsenal Sarandi (ARG) <colgroup><col><col><col span="2"><col><col span="2"><col></colgroup><tbody> </tbody>

<colgroup><col><col><col span="2"><col><col span="2"><col></colgroup><tbody>
</tbody>

For example, Tigre played a game on 10/1/19, but has another game scheduled on 10/5/19. I only want ot be able to pull the date of the last game played. The formula I used used to match (I think) the team name on the table with the team name in another, and then find if there was a number for the score, and from there grab the date.

Any and all help is greatly appreciated.

 

[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:78.89px;" /><col style="width:55.13px;" /><col style="width:203.41px;" /><col style="width:208.16px;" /><col style="width:14.26px;" /><col style="width:14.26px;" /><col style="width:13.31px;" /><col style="width:19.01px;" /><col style="width:26.61px;" /><col style="width:202.46px;" /><col style="width:94.1px;" /></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><td >D</td><td >E</td><td >F</td><td >G</td><td >H</td><td >I</td><td >J</td><td >K</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><td > </td><td > </td><td > </td><td > </td><td > </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="background-color:#fafafa; color:#333333; font-family:Verdana; font-size:9pt; text-align:right; ">10/01/2019</td><td style="text-align:right; ">1</td><td >Tigre (ARG)</td><td >San Martin Tucuman (ARG)</td><td style="text-align:right; ">0</td><td style="text-align:right; ">1</td><td >L</td><td >W</td><td > </td><td >Tigre (ARG)</td><td style="text-align:right; ">10/05/2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="background-color:#fafafa; color:#333333; font-family:Verdana; font-size:9pt; text-align:right; ">10/02/2019</td><td style="text-align:right; ">1</td><td >Agropecuario (ARG)</td><td >Deportivo Moron (ARG)</td><td style="text-align:right; ">0</td><td style="text-align:right; ">1</td><td >L</td><td >W</td><td > </td><td >Instituto Cordoba (ARG)</td><td style="text-align:right; ">10/04/2019</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="background-color:#fafafa; color:#333333; font-family:Verdana; font-size:9pt; text-align:right; ">10/03/2019</td><td style="text-align:right; ">1</td><td >Atletico Mitre (ARG)</td><td >Barracas Central (ARG)</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="background-color:#fafafa; color:#333333; font-family:Verdana; font-size:9pt; text-align:right; ">10/04/2019</td><td style="text-align:right; ">1</td><td >Flandria (ARG)</td><td >Tristan Suarez (ARG)</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="background-color:#fafafa; color:#333333; font-family:Verdana; font-size:9pt; text-align:right; ">10/04/2019</td><td style="text-align:right; ">1</td><td >Instituto Cordoba (ARG)</td><td >Quilmes (ARG)</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="background-color:#fafafa; color:#333333; font-family:Verdana; font-size:9pt; text-align:right; ">10/05/2019</td><td style="text-align:right; ">1</td><td >Almagro (ARG)</td><td >Tigre (ARG)</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="background-color:#fafafa; color:#333333; font-family:Verdana; font-size:9pt; text-align:right; ">10/05/2019</td><td style="text-align:right; ">1</td><td >Argentinos Jrs (ARG)</td><td >Arsenal Sarandi (ARG)</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </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 >K2</td><td >=SUMPRODUCT(MAX((($C$2:$C$8=J2)+($D$2:$D$8=J2))*($A$2:$A$8)))</td></tr></table></td></tr></table>