Jun 28 2021 06:02 PM
Hi,
I have a table with multiple columns. One of these column contains names. Another contains dates. I have used the ISNUMBER search option along with the MAX function to find the latest date for a specified name in the table from the name column. The formula is as below.
=MAX(IF(ISNUMBER(SEARCH("Aaaa",Sheet1!$I$2:$I$500)),Sheet1!$J$2:$J$500)).
What I want to do now is return the value of another column in the same row from which the highest date value has been returned. Is this possible? If so, how?
Regards,
Suren
Jun 28 2021 07:35 PM
Name | Date | Another Column | Name | Date | Another Column | |
Peter | 06.05.2012 | York | Frank | 15.10.2019 | Paris | |
Frank | 15.10.2019 | Paris | ||||
Jack | 23.01.2023 | Home | ||||
Frank | 01.12.2013 | Night | ||||
Frank | 17.04.2017 | Ship | ||||
Peter | 23.04.2015 | Horse | ||||
Jack | 06.10.2012 | Hammer |
=MAXIFS($B$2:$B$8,$A$2:$A$8,F2)
=FILTER($C$2:$C$8,($A$2:$A$8=F2)*($B$2:$B$8=G2))