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

[µo°Ý] ¤é´Á+¼Æ¦rªº³Ì«á¤@µ§

[µo°Ý] ¤é´Á+¼Æ¦rªº³Ì«á¤@µ§

½Ð±Ð...
¨ú³Ì«á¤@µ§, =IFERROR(LOOKUP(1,0/$B2:$H2,$B2:$H2),""), ¦]§t¦³¤é´Á, ¤½¦¡´N¤£À´¦p¦ó¤U¤F.

Book1.rar (6.54 KB)

=LOOKUP(1,0/(B2:G2>0),B2:G2)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# hcm19522

ª¦¤F¤@¤U¤å  hcm19522  ¤j¤jªº¤½¦¡¸Ñ»¡¦p¤U¡G
"­ì¥»ªº·N«ä¬O从
0/B2:G2 这个数组¤¤§ä 1 这个数Õu¡]¦V¤U­Ý®e¡^¡AµM¦Z显¥Ü对应 B2:G2 这个数组¤¤ªº数Õu¡C
"¦ý¬O该¤½¦¡ÌÛ«ä«Ü¥©§® 0/B2:G2 这组数Õu实际¤W³£¬O 0 ©ÎªÌ «Dªk数Õu¡]当 B2:G2 ¤¤¦³数Õu为0时¡^
¡A这样¤@来¡A=LOOKUP(1,0/B2:G2,B2:G2) ¤½¦¡´N变¦¨¤F ¬d§ä B2:G2 ¤¤³Ì¦Z¤@个¤£为 0 ªº数Õu¡C

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2019-12-11 13:43 ½s¿è

¦^´_ 3# jeffrey628litw

«D¼Æ¦r =LOOKUP("¼_",B2:G2)

³Ì«á¬O¼Æ¦r=LOOKUP(9^9,B2:G2)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 4# hcm19522

    ·PÁ  hcm19522  ¤j¤j ªº¸Ñ»¡«ü¾É¡C

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD