LearnExcel&VBA
Member
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.
Looking to remove extra ------.
=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 ------.