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

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

=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

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD