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

Excel¤ñ¹ï¤é´Áªº°ÝÃD

Excel¤ñ¹ï¤é´Áªº°ÝÃD

Àx¦s®æ
A1      8/1   B1 8/10
A2      8/3
A3      8/5
A4      8/9
A5     8/15
©óA6³B§Ú­n¤ñ¹ïA1~A5ªº¤é´Á¤ñB1¤pªº¦³´X­Ó¡C
A¤½¦¡=COUNTIF(A1:A5,"<=B1")¡A­pºâ¥X¨Ó¬°0­Ó¡A
¦ýB¤½¦¡=COUNTIF(A1:A5,"<=8/10")¡A­pºâ¥X4­Ó¡C
½Ð±Ð¡A¦]B1¬O·|Åܧ󪺡A©Ò¥H¨C¦¸³£­n¦b¶i¤J¤½¦¡¤º­×§ï¡A³o¦³ÂI¬°Ãø¡C¦]¦¹½Ð¦U¦ì«e½ú¨ó§U¬Ý§Ú¼gªºA¤½¦¡¤è¦¡¦³¨º¸Ì¿ù»~©O?
Jodie

¦^´_ 1# chwjj5059
=COUNTIF(A1:A5,"<="&B1)

TOP

¦^´_ 2# stillfish00
«D±`ÁÂÁÂ!!
§Ú·Q¦A½T»{¤@¤U¡A&ªº©w¸q¬O¬Æ»ò·N«ä©O?
Jodie

TOP

¦^´_ 3# chwjj5059
¦r¦ê³sµ²¹Bºâ¤l¡A±N²Å¸¹¨â°¼³sµ²¦¨³æ¤@¦r¦ê

TOP

A¤½¦¡=COUNTIF(A1:A5,"<="&B1")
B¤½¦¡=COUNTIF(A1:A5,"<=8/10")
³o¨â­Ó¦¡¤l¥H§A¥Ø«eªº¨Ò¤l°õ¦æ«áµª®×¥i¯à¬O¤@¼Ëªº¡A¦ý³o¨â­Ó¦¡¦³®t²§ªº¡C
©ñ¤@¦~«á¦A°õ¦æ¡AB¤½¦¡©Ò±oªº¼Æ¶q·|§ó¦h¡C
"<=8/10" ¦b¤µ¦~¨t²ÎÀq»{¬° "<=2013/8/10"¡A¥i¬O¨ì©ú¦~¨t²ÎÀq»{¬° "<=2014/8/10"
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# ML089

ÁÂÁ±zªº¸Ñ»¡
Jodie

TOP

        ÀR«ä¦Û¦b : ¯àµ½¥Î®É¶¡ªº¤H¡A¥²¯à´x´¤¦Û¤v§V¤Oªº¤è¦V¡C
ªð¦^¦Cªí ¤W¤@¥DÃD