- ©«¤l
- 7
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 18
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN 7
- ³nÅ骩¥»
- Office2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2012-6-29
- ³Ì«áµn¿ý
- 2014-1-1
|
¥»©«³Ì«á¥Ñ CyaTu ©ó 2012-7-3 11:47 ½s¿è
«z! ·PÁÂHUNGCHILINªº»¡©ú¡A
±zªº³¡¸¨®æÅý§Ú¨ü¯q¨}¦h¡Aª½¦¡ªºÅçÃÒ§Ú¤]¦³¤U¸ü¨Ó¬Ý¹L¡A¦ý¦]¬°¥LªºDATA¤ñ¸û²³æ¡A¥u¦³¤@¦C¡A
¾î¦¡ªºDATA¬OX-Yªí®æªº«¬ºA¡A¤ñ¸û²Å¦X§Ú¥Ø«eªº»Ý¨D¡A¥i¼W¥[¦C¡B¤]¥i¼W¥[Äæ...
§ÚÀˬd¹L¡A³oÓÅçÃÒªº³¡¤ÀÀ³¸Ó¨S¦³¥Î¨ìVBA¡A§Ú¤]¤@ÓÓ¤½¦¡¥á¨ìÀx¦s®æ¥h¸Ñ¶}¡Aµo²{°ß¦³§ÚªºÀɮפ¤¦WºÙ©w¸q¬°Heighªº¡A¶]¤£¥XÈ¡C
¦b±zªºìÀɤ¤¡A©R¦W¬°MaxA
¦ý¦]¬°ª½¾î¤£¦P
©Ò¥H±zì¥ýªºMaxA¼gªº¬O
=MATCH(2,1/(OFFSET(DATABASE!$1¡G$1,DATA,0)<>""))
§ÚªºHeigh«h§ï¦¨
=MATCH(2,1/(OFFSET(DATA!$A¡G$A,0,toClass)<>""))
¦ýOFFSETªº¨º¤@¬q¨ç¼Æ¡A«ç»ò¤]¶]¤£¥X¡C
§Ú¬Æ¦Ü§âtoClassªº©w¸qª½±µ§ï¬°¼Æ¦r´À¥N¬Ý¬Ý¡Aµ²ªGÁÙ¬O¤@¼Ë¡C
¯uªº»Ý¦U¦ì«e½úÀ°§Ú¸Ñ´b¡AÁÂÁ¡I |
|