Right Direction

[JackGu]

Hi all,

I was hoping that someone could help point me in the right direction with a set of data.

I've attached an example of the data set that I'm working with, what I need is for the data to appear next to the name in relation to the date.

I hope this doesn't come across as asking for the formula, but rather I just don't know where to start googling : (

I would really appreciate a hand on this one.

Thank you,

Jack

[José Augusto]

Hi
Try this formula
=INDEX($B$3:$B$18,MATCH(D2,$A$3:$A$18,0))
or this
=VLOOKUP(D2,$A$3:$B$18,2,FALSE)

[JackGu]

Thank you so much for the response, but I mightn't have explained myself well enough.

I was hoping for the data returned to match the date in D1, which is where I'm stumped : (

[KOKOSEK]

Problem imho is because you've got dates and names in the same column.
I've split it into 2 helper columns (G & H) like this:

	G	H
1	helpers
2
3	Nomie - 123456
4	Nomie - 123456	01/08/2020
5	Nomie - 123456	03/08/2020
6	Nomie - 123456	06/08/2020
7	Nomie - 123456	07/08/2020
8	Nomie - 123456	08/08/2020
9	Nomie - 123456	10/08/2020
10	Jack - 234567
11	Jack - 234567	01/08/2020

	G	H
1	helpers
2
3	=IFERROR(IF(FIND("-",A3),A3,""),G2)	=IFERROR(DATEVALUE(TEXT(A3,"dd/mm/yy")),"")
4	=IFERROR(IF(FIND("-",A4),A4,""),G3)	=IFERROR(DATEVALUE(TEXT(A4,"dd/mm/yy")),"")
5	=IFERROR(IF(FIND("-",A5),A5,""),G4)	=IFERROR(DATEVALUE(TEXT(A5,"dd/mm/yy")),"")

(drag it down as long as needed)

then with these:

	D	E
1	01/08/2020	Ready Time Adherence (%)
2	Nomie - 123456	=SUMIFS(B:B,H:H,$D$1,G:G,D2)
3	Jack - 234567	=SUMIFS(B:B,H:H,$D$1,G:G,D3)
4	Ashley - 345678	=SUMIFS(B:B,H:H,$D$1,G:G,D4)

you should get what you want:

	D	E
1	01/08/2020	Ready Time Adherence (%)
2	Nomie - 123456	82.67%
3	Jack - 234567	90.86%
4	Ashley - 345678	77.57%

[JackGu]

You're my hero!

Thank you : )

[José Augusto]

Try this in D2 and copy down
=IFERROR(INDEX($A$3:$A$100,AGGREGATE(15,6,ROW($A$1:$A$100)/(CODE(LEFT($A$3:$A$100,1))>57),ROW(A1))),"")

[KOKOSEK]

You're my hero!

Thank you : )

Happy to help.