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

¤½¦¡«ö·Ó¾FªñÀx¦s®æ³W«h§ïÅÜ

¤½¦¡«ö·Ó¾FªñÀx¦s®æ³W«h§ïÅÜ

¦U¦ì¦n:
§Ú¦³­Ó¤½¦¡§Æ±æ¯àÀHµÛ¹j¾ÀªºÀx¦s®æ°µÅܤÆ
ªþÀɸÌBÄæ¬O¶i¦æ¼Ðµùªº¦C.

²Ä¤@¦¸¬Ý¨ìBÄ欰¤@¡A¦bB18ªº¦ì¸m
C18§Úªº¤½¦¡¬O= max(A4:A18)
D18§Úªº¤½¦¡¬O= min(A4:A18)
E18§Úªº¤½¦¡¬O= Average(C18:D18)

¦Ó¤U¤@¦¸¬Ý¨ìBÄæ¦AÅÜ1®É¡A¤]´N¬O¦bB38ªº¦ì¸m ¥H¦¹Ãþ±À...
C38ªº¤½¦¡§Ú·Q­n¼g = max(A19:A38)
D38ªº¤½¦¡§Ú·Q­n¼g = min(A19:A38)
E38§Úªº¤½¦¡¬O= Average(C38:D38)

¤j·§¬O³o¼Ë¦A³Â·Ð¦U¦ì°ª¤â¸Ñµª¤F..

G.gif (620.11 KB)

G.gif

G.gif (620.11 KB)

G.gif

G.gif (620.11 KB)

G.gif

Question.rar (100.79 KB)

¢Ò¢³¡G
=IF($B4=1,SUBTOTAL(COLUMN(D$1),OFFSET($A4,,,MMULT(1,MAX(($B$1:$B3=1)*ROW(B$1:B3),3)-ROW()))),"")¡@¥k©Ô¤@®æ¡D¤U©Ô

¢Ô¢³¡G
=IF($B4=1,(D4+E4)/2,"")¡@¤U©Ô

TOP

·PÁÂÀ°¦£!! §Ú¸Õ¬Ý¬Ý!

TOP

MMULT(1,MAX(($B$1B3=1)*ROW(B$1:B3),3)-ROW())))

²a¤j¦n¡A±z¶Kªº¦¡¤l§Ú¤j·§³£¤F¸Ñ¤F¡A¦ý³o±ø¹ê¦b¬Ý¤£À´¡A²Ä¤@¬OMAX¸Ì¥]ªº¨º¨ÇªF¦è¬O¤°»ò·N¸q
B1:B3=1 ³oÃä¬O? Row(B$1:B3)³o¸Ì·|¦]¬°¤U©Ô¦Ó¥]ªº¶V¦h¦ýÀ³¸Ó³£¥u·|¹ïÀ³¨ìB1³o­ÓÀx¦s®æ§a?
MMULT¬O¨â­Ó¯x°}¬Û­¼¦ý§Ú¬Ý¤£À´§A³o¸Ì¬O¦b°µ¤°»ò...

TOP

        ÀR«ä¦Û¦b : ¤£­nÀH¤ß©Ò±ý¡A­nÀH¤ß±Ð¨|¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD