- ©«¤l
- 678
- ¥DÃD
- 147
- ºëµØ
- 0
- ¿n¤À
- 799
- ÂI¦W
- 0
- §@·~¨t²Î
- win 8
- ³nÅ骩¥»
- MS 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-2-9
- ³Ì«áµn¿ý
- 2022-1-20
|
¥»©«³Ì«á¥Ñ ziv976688 ©ó 2021-1-16 06:10 ½s¿è
¦^´_ 2# ziv976688
¨S¦³·Q¨ì±N"©w¼Æ(>10)§ï¬°¤£©w¼Æ(¦U³æÄæ³Ì¤jÈ)·|³o»òÃø>*<
´«¥t¤@Ó´£°Ý¤è¦¡~
2021-0105
B2=IF(ISERROR(SMALL(IF(A!$B$2:$B$51=MAX(A!$B$2:$B$51),A!$A$2:$A$51),COLUMN(A$1))),"",SMALL(IF(A!$B$2:$B$51=MAX(A!$B$2:$B$51),A!$A$2:$A$51),COLUMN(A$1)))
B3=IF(ISERROR(SMALL(IF(A!$C$2:$C$51=MAX(A!$C$2:$C$51),A!$A$2:$A$51),COLUMN(A$1))),"",SMALL(IF(A!$C$2:$C$51=MAX(A!$C$2:$C$51),A!$A$2:$A$51),COLUMN(A$1)))
:
:
B18=IF(ISERROR(SMALL(IF(A!$R$2:$R$51=MAX(A!$R$2:$R$51),A!$A$2:$A$51),COLUMN(A$1))),"",SMALL(IF(A!$R$2:$R$51=MAX(A!$R$2:$R$51),A!$A$2:$A$51),COLUMN(A$1)))
B19=IF(ISERROR(SMALL(IF(A!$S$2:$S$51=MAX(A!$S$2:$S$51),A!$A$2:$A$51),COLUMN(A$1))),"",SMALL(IF(A!$S$2:$S$51=MAX(A!$S$2:$S$51),A!$A$2:$A$51),COLUMN(A$1)))
½Ð°Ý : ¦p¦ó±N¤Wz18Ó¤½¦¡Â²¤Æ¬°¤@¦¡¤U©Ô¦¨®×ªº¤½¦¡?
ÁÂÁÂ! |
|