find 5 oldest files and their names based their status

[superjoe84]

F2 = {=INDEX(A2:A11,MATCH(LARGE(IF(B2:B11="in",C2:C11),1),C2:C11,0),1)}
F3 = {=INDEX(A2:A11,MATCH(LARGE(IF(B2:B11="in",C2:C11),2),C2:C11,0),1)}
F4 = {=INDEX(A2:A11,MATCH(LARGE(IF(B2:B11="in",C2:C11),3),C2:C11,0),1)}
and so on to find the 5 oldest files in order of oldest first. this works fine if the number of days is different on all, but when there is duplication and the file above is out, MATCH() finds it before the file that is in. eg F6 should read 3 instead of 2. does any of that make sense to anyone other than me? this is just a sampling, my document looks at over a hundred entries so this error occurs a lot. how do i fix it?

 

[AlphaFrog]

Excel Workbook
	A	B	C	D	E
1	file #	in\out	days		Oldest
2	1	in	25		4
3	2	out	17		10
4	3	in	17		1
5	4	in	32		8
6	5	out	7		3
7	6	out	5
8	7	out	9
9	8	in	24
10	9	out	24
11	10	in	30
Sheet

 

[superjoe84]

works beautifully! Thank you so much for saving my brain