Find a name, then find latest date, then find coresponding text in same row..........

More specifically:

Column A has a list of dates with times
Column B has a list of names
Column C has either a Yes or No

I need it to locate a specific name in Column B, then find the most recent date with most recent time in Column A corresponding to the name in Column B, then I need it to tell me whether it says Yes or No in Column C.

I've been able to get it to find all the info I need separately but I can't seem to figure out how to get them to work all together.

Hope that made sense, thanks!

Let A:C house the data you specified from row 2 downwards.

Let E2 house a name of interest.

F2, control+shift+enter, not just enter:

=INDEX($C$2:$C$8,MATCH(1,IF($B$2:$B$8=$E2,IF($A$2:$A$8=MAX(IF($B$2:$B$8=$E2,$A$2:$A$8)),1)),0))

Workbook.xlsx

Hopefully that attached correctly.

So looking at it, start with BILL. I'm trying to get it to find BILL, then find the latest date/time stamp for BILL, then find what is in the same row as that but in column C and tell me if it is yes or no.

to: Aladin Akyurek

"Let A:C house the data you specified from row 2 downwards.

Let E2 house a name of interest.

F2, control+shift+enter, not just enter:

=INDEX($C$2:$C$8,MATCH(1,IF($B$2:$B$8=$E2,IF($A$2:$A$8=MAX(IF($B$2:$B$8=$E2,$A$2:$A$8)),1)),0))"

I put this in but it's not giving me the most recent answer for the name of interest. I'll play around with it, thanks for a start!!

Originally Posted by ELeGault

Can you post a sample of said data.

GO Advanced (ALT+X)

In it, have a clear output format of what you are looking for.

Now if you think you have the solutions separately.. you can combine them with a &" "& between your formulas, which will add a space and then complete the next solution

I'll try the & idea, thanks.

See the attachment, which is exactly equivalent to the description I provided.

Originally Posted by Aladin Akyurek

See the attachment, which is exactly equivalent to the description I provided.

Thanks man! Not entirely sure where I screwed up transposing it the first time..........but thanks again! Perfecto!

You are welcome.