ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

½Ð°Ý³oÀx¦s®æ¤º¨ç¼Æ¥i¥H²¤Æ¶Ü?

½Ð°Ý³oÀx¦s®æ¤º¨ç¼Æ¥i¥H²¤Æ¶Ü?

½Ð°Ý³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)

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# hcm19522


    ·PÁ¤j¤jªº«ü¾É¤À¨É¡A§¹¥þ²Å¦X§Ú·Q­nªº¡C

TOP

        ÀR«ä¦Û¦b : ­n§åµû§O¤H®É¡A¥ý·Q·Q¦Û¤v¬O§_§¹¬üµL¯Ê¡C
ªð¦^¦Cªí ¤W¤@¥DÃD