formula too long error

[gn82]

Hi,

Can someone please help me either simplify this formula or work around the excel formula error ?

My formula is aimed running through the positions (ranks) athletes occupy at the end of each of their 34 yearly contests and present a summary such as: "3 P1, 2 P2, 1 P5" which means the contestant occupied 3 number 1 spots, 2 number 2 spots and 1 number 5 spot during the season.

=LEFT(IF(SUM(CHOOSE($C52:$AJ52,1,0,0,0,0,0,0,0,0,0)),SUM(CHOOSE($C52:$AJ52,1,0,0,0,0,0,0,0,0,0))&" P1, ","")&
IF(SUM(CHOOSE($C52:$AJ52,0,1,0,0,0,0,0,0,0,0)),SUM(CHOOSE($C52:$AJ52,0,1,0,0,0,0,0,0,0,0))&" P2, ","")&
IF(SUM(CHOOSE($C52:$AJ52,0,0,1,0,0,0,0,0,0,0)),SUM(CHOOSE($C52:$AJ52,0,0,1,0,0,0,0,0,0,0))&" P3, ","")&
IF(SUM(CHOOSE($C52:$AJ52,0,0,0,1,0,0,0,0,0,0)),SUM(CHOOSE($C52:$AJ52,0,0,0,1,0,0,0,0,0,0))&" P4, ","")&
IF(SUM(CHOOSE($C52:$AJ52,0,0,0,0,1,0,0,0,0,0)),SUM(CHOOSE($C52:$AJ52,0,0,0,0,1,0,0,0,0,0))&" P5, ","")&
IF(SUM(CHOOSE($C52:$AJ52,0,0,0,0,0,1,0,0,0,0)),SUM(CHOOSE($C52:$AJ52,0,0,0,0,0,1,0,0,0,0))&" P6, ","")&
IF(SUM(CHOOSE($C52:$AJ52,0,0,0,0,0,0,1,0,0,0)),SUM(CHOOSE($C52:$AJ52,0,0,0,0,0,0,1,0,0,0))&" P7, ","")&
IF(SUM(CHOOSE($C52:$AJ52,0,0,0,0,0,0,0,1,0,0)),SUM(CHOOSE($C52:$AJ52,0,0,0,0,0,0,0,1,0,0))&" P8, ","")&
IF(SUM(CHOOSE($C52:$AJ52,0,0,0,0,0,0,0,0,1,0)),SUM(CHOOSE($C52:$AJ52,0,0,0,0,0,0,0,0,1,0))&" P9, ","")&
IF(SUM(CHOOSE($C52:$AJ52,0,0,0,0,0,0,0,0,0,1)),SUM(CHOOSE($C52:$AJ52,0,0,0,0,0,0,0,0,0,1))&" P10, ",""),LEN(
IF(SUM(CHOOSE($C52:$AJ52,1,0,0,0,0,0,0,0,0,0)),SUM(CHOOSE($C52:$AJ52,1,0,0,0,0,0,0,0,0,0))&" P1, ","")&
IF(SUM(CHOOSE($C52:$AJ52,0,1,0,0,0,0,0,0,0,0)),SUM(CHOOSE($C52:$AJ52,0,1,0,0,0,0,0,0,0,0))&" P2, ","")&
IF(SUM(CHOOSE($C52:$AJ52,0,0,1,0,0,0,0,0,0,0)),SUM(CHOOSE($C52:$AJ52,0,0,1,0,0,0,0,0,0,0))&" P3, ","")&
IF(SUM(CHOOSE($C52:$AJ52,0,0,0,1,0,0,0,0,0,0)),SUM(CHOOSE($C52:$AJ52,0,0,0,1,0,0,0,0,0,0))&" P4, ","")&
IF(SUM(CHOOSE($C52:$AJ52,0,0,0,0,1,0,0,0,0,0)),SUM(CHOOSE($C52:$AJ52,0,0,0,0,1,0,0,0,0,0))&" P5, ","")&
IF(SUM(CHOOSE($C52:$AJ52,0,0,0,0,0,1,0,0,0,0)),SUM(CHOOSE($C52:$AJ52,0,0,0,0,0,1,0,0,0,0))&" P6, ","")&
IF(SUM(CHOOSE($C52:$AJ52,0,0,0,0,0,0,1,0,0,0)),SUM(CHOOSE($C52:$AJ52,0,0,0,0,0,0,1,0,0,0))&" P7, ","")&
IF(SUM(CHOOSE($C52:$AJ52,0,0,0,0,0,0,0,1,0,0)),SUM(CHOOSE($C52:$AJ52,0,0,0,0,0,0,0,1,0,0))&" P8, ","")&
IF(SUM(CHOOSE($C52:$AJ52,0,0,0,0,0,0,0,0,1,0)),SUM(CHOOSE($C52:$AJ52,0,0,0,0,0,0,0,0,1,0))&" P9, ","")&
IF(SUM(CHOOSE($C52:$AJ52,0,0,0,0,0,0,0,0,0,1)),SUM(CHOOSE($C52:$AJ52,0,0,0,0,0,0,0,0,0,1))&" P10, ",""))-2)

Thanks in advance !

[zbor]

can you upload example workbook and write what you want to get?

So some inputs and desired output.