- ©«¤l
- 2
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 3
- ÂI¦W
- 0
- §@·~¨t²Î
- windows7
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2014-12-18
- ³Ì«áµn¿ý
- 2014-12-19
|
excelªº数¦r±Æ¦C¨D§U
¨D§U¦U¦ì°ª¤â¡A
§Ú¦b¤u§@¤¤¹J¨ì¤@个问题¡A¬Ý着®¼简单ªº¡A´N¬O¾ã¤£¥X来¡A¤j®a帮帮¦£
A¦C¦³¥H¤U数¦r¡A随«K¤°¤\³£¥i¥H`.¥i¥H«Î`ªº¡C¡C§Ú¥Î=COUNT(1/FREQUENCY(A1:A100,A1:A100))``计ºâ¥X¡A±o¨ì没¦³«Î`ªº12个数¦rªº个数¡A
现¦b»Ýn¦bB¦C ¥Î¤½¦¡¥Í¦¨从从¤p¨ì¤j1开©lªº数¦r¡A¤¤间没¦³间断¡A´N¬O¤U±¨º样¡C¤£¯à¥Îmacroµ{§Ç
A B
13 8
3 2
3 2
5 4
7 5
12 7
12 7
11 6
15 9
16 10
18 11
22 12
4 3
4 3
4 3
4 3
2 1
2 1
2 1
2 1
«ô¦«
¤j®a¤F |
|