Grabbing Last Value of Column, but...

rackem12

New Member
Joined
Jun 21, 2017
Messages
11
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/191.00Tigre (ARG)San Martin Tucuman (ARG)01LW
10/02/191.00Agropecuario (ARG)Deportivo Moron (ARG)01LW
10/03/191.00Atletico Mitre (ARG)Barracas Central (ARG)
10/04/191.00Flandria (ARG)Tristan Suarez (ARG)
10/04/191.00Instituto Cordoba (ARG)Quilmes (ARG)
10/05/191.00Almagro (ARG)Tigre (ARG)
10/05/191.00Argentinos 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.
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,079
Office Version
2007
Platform
Windows
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>
 

Watch MrExcel Video

Forum statistics

Threads
1,095,350
Messages
5,443,954
Members
405,258
Latest member
daveyf

This Week's Hot Topics

Top