- ©«¤l
- 112
- ¥DÃD
- 32
- ºëµØ
- 0
- ¿n¤À
- 164
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-4
- ³Ì«áµn¿ý
- 2024-2-20
|
¤@¼ÓªþÀÉ//¥u¾A¥Î¯Â¼ÆÈ
=IF(OR(MMULT(1-ISERROR(RANK(B4:J12,B20:F20)),ROW(B4:B12)^0)>2),"X","")
ã´£³¡ªL µoªí©ó 2023-3-7 22:39
·PÁ´£³¡ªL ¥ý¶i..¥N¤J«á²£¥Í#VALUE...
IF(OR(MMULT(1-ISERROR(RANK($BH$1:$BR$13,N18:S18)),ROW($2:$12)^0)>2),"X","")
«á§ï¦¨ ROW(B4:B12)=ROW(B2:B12) ¤]ÅçÃÒ¦¨¥\
¯u¬O©Ç²§..¨¯W¤T¦ì¥ý¶i.. |
|