- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 258
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-28
|
¦^´_ 36# Bodhidharma
1.³o¼Ë¥i¶Ç¦^¦P¸s²Õ¤ºBÄæ¦U¼ÆȪº²Ä¤@¦¸¥X²{ªº¦ì¸m¡A¶Ç¦^¸Ó¼ÆÈ¥X²{¦¸¼Æ
=FREQUENCY(OFFSET($B$1,MATCH($A2,$A:$A,0)-1,,COUNTIF($A:$A,$A2),)*10^0,OFFSET($B$1,MATCH($A2,$A:$A,0)-1,,COUNTIF($A:$A,$A2),)*10^0)
2.³o¼Ë§PÂ_¬O§_BÄæ¼ÆȬ°³sÄò¥X²{
=(FREQUENCY(INDIRECT("RC2:R"&MATCH($A2,$A:$A,0)+COUNTIF($A:$A,$A2)-1&"C2",0)*10^0,INDIRECT("RC2:R"&MATCH($A2,$A:$A,0)+COUNTIF($A:$A,$A2)-1&"C2",0)*10^0)=FREQUENCY(INDIRECT("R[1]C2:R"&MATCH($A2,$A:$A,0)+COUNTIF($A:$A,$A2)-1&"C2",0)*10^0,INDIRECT("R[1]C2:R"&MATCH($A2,$A:$A,0)+COUNTIF($A:$A,$A2)-1&"C2",0)*10^0)+1)
3.CÄæ¥un¬O¥H¤W¨â±ø¥ó§k¦X´N¬O¸Ó¸s²Õ³sÄò³Ì¦hªº²³¼Æ
¨âÓ§PÂ_¦¡¬Û¼¦A¼¤WBÄ檺ȡA´N¯à±o¨ìµª®×
²³¼Æ.rar (12.04 KB)
|
|