I am attempting to test a column for a precise title (in my pictured instance, JonP and never JonF) and return the time that seems within the row above the title. I’ve been in a position to determine learn how to return the primary occasion through the use of this system =IFERROR(INDEX(A$2:A$9,MATCH("*"&$D2&"*",A$2:A$9,0)-1,1),"")

What I need to do is locate each cases of JonP after which use TEXTJOIN to listing the instances which are above every occasion of JohnP.

I’ve regarded on the examples on these 2 pages:

  1. https://trumpexcel.com/lookup-second-value/
  2. https://www.get-digital-help.com/index-match-multiple-results/
    …however my understanding of how the completely different capabilities are interacting in these examples is just too tenuous for me to determine learn how to apply it to my scenario, which is completely different, since I am solely wanting in 1 column and need to return the worth within the row above the match.

example

2 many shoos is a brand new contributor to this website. Take care in asking for clarification, commenting, and answering.
Try our Code of Conduct.

2