Formula Modification Required

[LearnExcel&VBA]

Using below formula to get the desired result but there is problem that i want to fix please help in this regard.

=IF(C3="Early",C2,"")&" - "&IF(D3="Early",D2,"")&" - "&IF(E3="Early",E2,"")&" - "&IF(F3="Early",F2,"")&" - "&IF(G3="Early",G2,"")&" - "&IF(H3="Early",H2,"")&" - "&IF(I3="Early",I2,"")&" - "&IF(J3="Early",J2,"")&" - "&IF(K3="Early",K2,"")&" - "&IF(L3="Early",L2,"")&" - "&IF(M3="Early",M2,"")&" - "&IF(N3="Early",N2,"")&" - "&IF(O3="Early",O2,"")&" - "&IF(P3="Early",P2,"")&" - "&IF(Q3="Early",Q2,"")&" - "&IF(R3="Early",R2,"")&" - "&IF(S3="Early",S2,"")&" - "&IF(T3="Early",T2,"")

Its result is like.

Kim - Din - Lin - - - - - - - - - - - - - - -

Looking to remove extra ------.

 

[pecoflyer]

Post a sample sheet

 

[bosco_yip]

Your formula need TEXTJOIN function of which available in Office 365 or Excel 2019

=TEXTJOIN("-",1,IF(C3:T3="Early",C2:T2,""))

• It will be a normal formula if your Office 365 have dynamic array function.
• It will be an array (CSE) formula if your Office 365 don't have dynamic array function, or you have Excel 2019.

 

[LearnExcel&VBA]

Here is attached sheet.