LARGE Function

[Jar888]

I might be missing something stupid, but I can't work out when two numbers are of the same value how to make it display both in sequential order rather than the same item twice then the 3rd;

2022-5 May - 54 Workshop Handover.xlsx
	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI
12	TRU039 - 24hrs								TRU013	23.5
13	- Concrete pump issue (1099800) - - Concrete pump issue								TRU039	24
14									TRU046
15	TRU039 - 24hrs								TRU047	0.5
16	- Concrete pump issue (1099800) - - Concrete pump issue								TRU054	24
17									TRU055
18	TRU013 - 23.5hrs
19	- Remote not working (1100103) - - Remotes not working
Availability

Cell Formulas
Range	Formula
AH12:AH17	AH12	=L7
AI12:AI17	AI12	=IF(SUM(M7:N7)=0,"",SUM(M7:N7))
Z12	Z12	=IFERROR(INDEX($AH$12:$AH$17,MATCH(LARGE($AI$12:$AI$17,1),$AI$12:$AI$17,0))&" - "&LARGE($AI$12:$AI$17,1)&"hrs","")
Z13	Z13	=IFERROR(IF(LARGE($AI$12:$AI$17,1)>0,INDEX($B$41:$B$46,MATCH(LARGE($AI$12:$AI$17,1),$AI$12:$AI$17,0))&" - "&INDEX($F$41:$F$46,MATCH(LARGE($AI$12:$AI$17,1),$AI$12:$AI$17,0)),""),"")
Z15	Z15	=IFERROR(INDEX($AH$12:$AH$17,MATCH(LARGE($AI$12:$AI$17,2),$AI$12:$AI$17,0))&" - "&LARGE($AI$12:$AI$17,2)&"hrs","")
Z16	Z16	=IFERROR(IF(LARGE($AI$12:$AI$17,2)>0,INDEX($B$41:$B$46,MATCH(LARGE($AI$12:$AI$17,2),$AI$12:$AI$17,0))&" - "&INDEX($F$41:$F$46,MATCH(LARGE($AI$12:$AI$17,2),$AI$12:$AI$17,0)),""),"")
Z18	Z18	=IFERROR(INDEX($AH$12:$AH$17,MATCH(LARGE($AI$12:$AI$17,3),$AI$12:$AI$17,0))&" - "&LARGE($AI$12:$AI$17,3)&"hrs","")
Z19	Z19	=IFERROR(IF(LARGE($AI$12:$AI$17,3)>0,INDEX($B$41:$B$46,MATCH(LARGE($AI$12:$AI$17,3),$AI$12:$AI$17,0))&" - "&INDEX($F$41:$F$46,MATCH(LARGE($AI$12:$AI$17,3),$AI$12:$AI$17,0)),""),"")

 

[Fluff]

For Z12 try

=IFERROR(INDEX($AH$12:$AH$17,AGGREGATE(15,6,(ROW($AH$12:$AH$17)-ROW($AH$12)+1)/(LARGE($AI$12:$AI$17,1)=$AI$12:$AI$17),1))&" - "&LARGE($AI$12:$AI$17,1)&"hrs","")