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

[µo°Ý] §ì³Ì·s¤@µ§¸ê®Æ

[µo°Ý] §ì³Ì·s¤@µ§¸ê®Æ

½Ð±Ð¥ý¶i:
¦p¦ó§ì³Ì·s¤@µ§E8 = H1  ¤½¦¡  »¡©ú¦b¤º
ÁÂÁÂ!

³Ì·s.rar (7.38 KB)

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

TOP

hcm19522 µoªí©ó 2019-1-30 10:43


¥ý·PÁÂHCM¤j¤j
§Ú±Ä¥Î²Ä2ºØ¤è¦¡ ,§ì¨ìªº¬ODÄæ,,­nEÄæ¸ê®Æ¦p¦ó§ï?  ¤p§Ì²Â©å..ÁÂÁÂ

TOP

¦^´_ 3# duck_simon

¸Õ¸Õ¬Ý³o¼Ë¥i¥H¶Ü? ¦pªG¥u§ìEÄ檺¸Ü...
H1  {=INDIRECT("E"&LARGE(IF(E1:E200<>"",ROW(E1:E200)),1))}

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2019-1-30 16:11 ½s¿è

¦^´_ 1# duck_simon

§ä¨ì³Ì«á¤@¦C³Ì«áÄ檺¼Æ­È
    °}¦C¤½¦¡
=LOOKUP(9.9E+307,INDEX($B:$E,MAX(IF($B:$E<>"",ROW($B:$E),"")),))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  duck_simon

¸Õ¸Õ¬Ý³o¼Ë¥i¥H¶Ü? ¦pªG¥u§ìEÄ檺¸Ü...
H1  {=INDIRECT("E"&LARGE(IF(E1:E200"",ROW ...
lukychien µoªí©ó 2019-1-30 14:09

·PÁ   lukychien ¤j ,¥i¥H¤F ¥¿½T
®L¤jªº ÁÙ¬O§ä¨ìDÄæ  ??  ÁÙ¬OÁÂÁ¤F!

TOP

=INDEX(B:E,ROUNDUP(COUNT(B:E)/4,0),MOD(COUNT(B:E)-1,4)+1)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¤½¦¡¦Aµu¤@ÂI
=LOOKUP(9^9,OFFSET(B1:E1,COUNT(B:B)-1,))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2019-1-31 11:04 ½s¿è

¦pªG¼Æ­È³£¬O¥¿¼Æ®É
=-1/LOOKUP(,-1/OFFSET(B1:E1,COUNT(B:B)-1,))


¥u¨DEÄæ³Ì«á

=-1/LOOKUP(,-1/E:E)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦pªG¼Æ­È³£¬O¥¿¼Æ®É
=-1/LOOKUP(,-1/OFFSET(B1:E1,COUNT(B:B)-1,))


¥u¨DEÄæ³Ì«á

=-1/LOOKUP(,-1/E ...
ML089 µoªí©ó 2019-1-31 10:56



·PÁ  ¦]¨Sª`·N¨ì®ø®§..­Pºp..·P®¦«ü¾É...

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD