- ©«¤l
- 913
- ¥DÃD
- 150
- ºëµØ
- 0
- ¿n¤À
- 1089
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- office 2019
- ¾\ŪÅv
- 50
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-8-28
- ³Ì«áµn¿ý
- 2023-7-19
|
AÄ榳³\¦h¤£¦P¼ÆÈ,µ§¼Æ¦³´X¸Uµ§,¥Îcountifpºâ¥X²{¦¸¼Æ¤Î²Ä´X¦¸¥X²{,³£«Üªá®É¶¡,¤£ª¾¬O½d³ò¤Ó¤j©Îcountif¤ñ¸û¦Y¸ê·½¡H
µ²ªG2¥i¥H¥ÎC2=SUMPRODUCT((E$2:E$27=E2)*1)±o¨ì§Únªºµ²ªG,
½Ð°Ýµ²ªG1²Ä´X¦¸¥X²{,¥i¥H¥ÎSUMPRODUCT©Î¨ä¥L¤ñ¸û¤£¦û¸ê·½ªº¨ç¼Æ§Ö³t±o¨ìµ²ªG¶Ü¡H
AÄæ µ²ªG1 µ²ªG2
20140307 1 10
20140307 2 10
20140307 3 10
20140307 4 10
20140307 5 10
20140307 6 10
20140307 7 10
20140307 8 10
20140307 9 10
20140307 10 10
20140312 1 1
20140321 1 1
20140326 1 1
20140409 1 1
20140416 1 1
20140519 1 1
20140702 1 1
20140711 1 1
D 1 2
D 2 2
MSO16040047 1 4
MSO16040047 2 4
MSO16040047 3 4
MSO16040047 4 4
MSO16040050 1 2
MSO16040050 2 2 |
|