½Ð°Ý³oÀx¦s®æ¤º¨ç¼Æ¥i¥H²¤Æ¶Ü?
IÄ檺¤½¦¡¥i¥H²¤Æ¶Ü?(¦]¬°¥u¯à¥Î¦b2010¥H«áªºExcel ª©¥»¡A2007¤£¯à¼g¥H¤U¨º»ò¦hªº¨ç¼Æ)
=IF(O2="GAA",IF(T2<>"",T2&" ","")&IF(U2="-","",U2&" ")&IF(V2<>"",V2&" ","")&IF(Z2<>"",Z2&" ","")&IF(AD2<>"",AD2&" ","")&IF(AE2<>"",AE2&" ","")&IF(W2<>"",W2&" ","")&IF(Y2<>"",Y2&" ","")&IF(AG2<>"",RIGHT(AG2,2),"")&IF(AG2<>"","-","")&IF(AH2<>"",RIGHT(AH2,2),"")&IF(AI2="-","","("&AI2&")"),IF(O2="GAF",IF(T2<>"",T2&" ","")&IF(U2="-","",U2&" ")&IF(V2<>"",V2&" ","")&IF(W2<>"",W2&" ","")&IF(X2<>"",X2&" ","")&IF(Y2<>"",Y2&" ","")&IF(Z2<>"",Z2&" ","")&IF(AD2<>"",AD2&" ","")&IF(AG2<>"",RIGHT(AG2,2),"")&IF(AG2<>"","-","")&IF(AH2<>"",RIGHT(AH2,2),"")&IF(AI2="-","","("&AI2&")"),IF(O2="GBE",IF(T2<>"",T2&" ","")&IF(U2="-","",U2&" ")&IF(V2<>"",V2&" ","")&IF(X2<>"",X2&" ","")&IF(AD2<>"",AD2&" ","")&IF(AC2<>"",AC2&" ","")&IF(W2<>"",W2&" ","")&IF(AE2<>"",AE2&" ","")&IF(Y2<>"",Y2&" ","")&IF(AG2<>"",RIGHT(AG2,2),"")&IF(AG2<>"","-","")&IF(AH2<>"",RIGHT(AH2,2),"")&IF(AI2="-","","("&AI2&")"),IF(O2="GAE",IF(T2<>"",T2&" ","")&IF(U2="-","",U2&" ")&IF(V2<>"",V2&" ","")&IF(W2<>"",W2&" ","")&IF(Y2<>"",Y2&" ","")&IF(X2<>"",X2&" ","")&IF(AA2<>"",AA2&" ","")&IF(AB2<>"",AB2&" ","")&IF(AC2<>"",AC2&" ","")&IF(AD2<>"",AD2&" ","")&IF(AE2<>"",AE2&" ","")&IF(AG2<>"",RIGHT(AG2,2),"")&IF(AG2<>"","-","")&IF(AH2<>"",RIGHT(AH2,2),"")&IF(AI2="-","","("&AI2&")"),""))))
ÀɮפU¸ü¡G
BCA 20191221-V.03 OKª©-F.rar (102.59 KB)
|