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

[µo°Ý] ¦p¦ó§PÂ_¦æªº¦ì¸m¡A¬d¥X¥I¶O°Ï¶¡¡C

[µo°Ý] ¦p¦ó§PÂ_¦æªº¦ì¸m¡A¬d¥X¥I¶O°Ï¶¡¡C

222.png
2019-5-31 13:30

¦p¦ó§PÂ_¦æªº¦ì¸m¡A¬d¥X¥I¶O°Ï¶¡¡C
ºâªA°È¶O¥I¨ì´X¤ë

test2.rar (7.21 KB)
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# hcm19522

ÁÂÁ¤j¤jªº±Ð¾É¡C

¦pªG§Ú¤§«á­n¥[¤ë¥÷¡A¬°¤°»ò·|¥X²{¿ù»~?
¦b³Â·Ð¤j¤j«ü±Ð...ÁÂÁÂ

test3.rar (8.54 KB)
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

TOP

{=IF(AND(D2:J2>0),"",INDEX(TEXT(("R"&D$1:J$1&"/1")*1,"E¦~M¤ë"),MAX(IF(D2:J2>0,COLUMN(A:G)))+1)&IF(I2>0,"","~"&"108¦~7¤ë"))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 4# hcm19522
=IF(AND(F5:AU5>0),"",INDEX(TEXT(("R"&F$4:AU$4&"/1")*1,"E¦~M¤ë"),MAX(IF(F5:AU5>0,COLUMN(A:AO)))+1)&IF(AQ4>0,"","~"&"108¦~6¤ë"))
¬O§Ú²Â¡A·í§Ú¸ê®Æ¶V¦h¤Ï¦Ó§ä¤£¨ì¤]
³Â·Ð¤j¤jÀ°¦£
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

TOP

test4.rar (27.94 KB) ¦^´_ 5# kkooo15


    §Ñ¤F¥[ÀÉ®×
ÁÂÁÂ
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

TOP

¦^´_ 6# kkooo15

=IF(AND(F5:AU5=0),"",INDEX(F$4:AU$4,MIN(IF(F5:AU5>0,COLUMN(A:AO)))))&"~"&IF(AND(F5:AU5=0),"",INDEX(F$4:AU$4,MAX(IF(F5:AU5>0,COLUMN(A:AO)))))
§Ú¤S¦b§ï¨}¤F¤@¤U
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

TOP

        ÀR«ä¦Û¦b : ÀR§¤±`®¦¤v¹L¡B¶¢½Í²ö½×¤H«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD