Concatenate Index Small Row

[croodsimian]

Guys,

So I'm using and index, small, row formula to find the nth occurrence of a result.

I'm using the below formula to concatenate the results.

{=CONCATENATE(INDEX(Table7[REPAIR NEEDED],SMALL(IF(Table7[ACTION]=$A$22,ROW(Table7[ACTION])-ROW(E24),""),1)),INDEX(Table7[REPAIR NEEDED],SMALL(IF(Table7[ACTION]=$A$22,ROW(Table7[ACTION])-ROW(E24),""),2)),INDEX(Table7[REPAIR NEEDED],SMALL(IF(Table7[ACTION]=$A$22,ROW(Table7[ACTION])-ROW(E24),""),3)))}

However, it only works if there are as many results as nth statements. So if i only have 1 or 2 occurrences, this formula does not work.

Can someone please offer a better formula?

Thanks.

Please let me know if my question is not clear enough.

 

[DanteAmor]

Try this:

{=IFERROR(INDEX(Table7[REPAIR NEEDED],SMALL(IF(Table7[ACTION]=$A$23,ROW(Table7[ACTION])-ROW(E24),""),1))," ")&IFERROR(INDEX(Table7[REPAIR NEEDED],SMALL(IF(Table7[ACTION]=$A$23,ROW(Table7[ACTION])-ROW(E24),""),2))," ")&IFERROR(INDEX(Table7[REPAIR NEEDED],SMALL(IF(Table7[ACTION]=$A$23,ROW(Table7[ACTION])-ROW(E24),""),3)),"")}

 

[croodsimian]

Thanks Dante, I was actually able to figure it out last night after posting.

 

[DanteAmor]

You're welcome