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

[µo°Ý] Ãö©ó±Æ¦W(§«ô¤»­n¥Î¤F>"<)

i2 =IF(H2<80,"",TEXT(1+COUNT(0/FREQUENCY(IF(H$2:H$99>H2,H$2:H$99),H$2:H$99)),"[<="&LOOKUP(COUNT(H$2:H$99),{4,5,9},{2,3,5})&"];"))
°}¦C¤½¦¡¿é¤J¡A¥ý«öctrl+shift¤£©ñ¡A¦b«öenter ¥H¤TÁä»ô«ö¤è¦¡¿é¤J¤½¦¡

±ø¥ó¤@¡B80¤À¥H¤W ¤~¦³¦W¦¸
¤½¦¡: =IF(H2<80,"", ...)

±ø¥ó¤G¡B¦pªG¦³4¤H°ÑÁÉ «h¨ú2­Ó¦W¦¸(2­Ó¦W¦¸¤£¬O2­Ó¤H)
5¤H°ÑÁɨú3­Ó¦W¦¸
9¤H°ÑÁɨú5­Ó¦W¦¸.....¥H¦¹Ãþ±À
¨Ò¦p 3­Ó¤H°ÑÁÉ «h¨ú2­Ó¦W¦¸ 1-2
6­Ó¤H°ÑÁÉ «h¨ú3­Ó¦W¦¸ 1-2-3
¤½¦¡: LOOKUP(COUNT(H$2:H$99),{4,5,9},{2,3,5})

±ø¥ó¤T¡B¹J¨ì¦P¤À®É ¨Ò¦p¦³¨â­Ó²Ä1¦W®É ¤£­n¸õ¹L¥h
¨Ò¦p 11­Ó¤H°ÑÁÉ ¦³¨â­Ó²Ä1¦W®É
¤£­n¬O 1-1-3-4-5-6 (2¤£¨£¤F)
¦Ó¬O­n 1-1-2-3-4-5-6 (2¦³¤F ¦Ó¥B­«½Æªº²Ä1¦W¨Ã¨S¦³­é¹Ü±¼²Ä6¦Wªº±o¼ú)
¤½¦¡: TEXT(1+COUNT(0/FREQUENCY(IF(H$2:H$99>H2,H$2:H$99),H$2:H$99)),"[<="& ¨ú´X¦W &"];"))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2016-3-22 08:40 ½s¿è

¦^´_ 8# kevenchin


    Text¨ç¼Æ¦^¶Çªº­È¬O¤å¦r¡A"1","2","3",
±N§A­ì¨Óªº¤½¦¡¤¤ªº1,2,3¼Æ¦r§ï¬°¤å¦r"1","2","3"§Y¥i¡C

§Ú¤½¦¡¤¤ªºText¨ç¼Æ¤]¥iª½±µ±N1,2,3§ï¬°¿é¥X¬°"²Ä¤@¦W","²Ä¤G¦W","²Ä¤T¦W"
§Ú¨ì¤½¥q¬d¤@¤U¦A¸Éµ¹§A¡C

½d¨Ò
=TEXT(ROW(),"[DBnum1]²Ä0¦W;")

±N¤½¦¡¤¤TEXT¨ç¼Æ¥~¥[¥t¤@­ÓTEXT¨ç¼Æ¦p¤U
=IF(H2<80,"",TEXT(TEXT(..., ...),"[DBnum1]²Ä0¦W"))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

=LOOKUP(COUNT(H$2:H$99),{1,2,3,4,5,6,7,8,9,10},{1,1,2,2,3,3,4,4,5,5})       
¤]¥i¥H²¤Æ¬°
=LOOKUP(COUNT(H$2:H$99),{1,3,5,7,9},{1,2,3,4,5})
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 11# kevenchin


J2 =IF(I2="",LOOKUP(H2,{0,60,70,80},{"","¥Òµ¥","Àuµ¥","¯SÀu"}),TEXT(I2,"[DBnum1]²Ä0¦W"))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : «Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD