- ©«¤l
- 65
- ¥DÃD
- 16
- ºëµØ
- 0
- ¿n¤À
- 82
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- 2013
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2010-5-25
- ³Ì«áµn¿ý
- 2019-12-3
|
¥»©«³Ì«á¥Ñ kaigan89 ©ó 2010-9-19 14:41 ½s¿è
=MAX(A1:A&B1)
¬O¿ùªº¡A½Ð°Ý¿ù¦b¦ó¦]¡H
¤S§ï¬°
=MAX("A1:A"&B1)
µª®×¬O#VALUE! ¤S¬O¬°¤°»ò¡H
OFFSET( )¤º¤Þ¼Æ¤£¥Î¥[¤Þ¸¹
¦ýINDIRECT(¡@¡@¡^¶·¥[¤Þ¸¹¡A¦³¨S¦³¥i¨Ì´`ªº³W«h¡H
½Ð¸Ô²Ó¸Ñ»¡¡A¥H§Q«á¾Ç¡IÁÂÁ |
|