- ©«¤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-10-8 17:25 ½s¿è
¦^´_ 5# ML089
¤£¶È¬O«D°}¦Cªº¤@¯ë¤½¦¡¸Ñ(§Q©ó®M¥Î¦bµ{¦¡½X)¡A¥Bºë©ú(§Q¥Î©T©wA&Bªº-2Äæ®t)¦Ó²µuªº¸Ñªk~
©Ó±Ð¤F~·P®¦
¥t¥~¦A©µ¦ù½Ð±Ð¡G
C19
=IF(C18="","",INDEX($1¡G$1,LARGE(IF(($C14¡G$AY14=C18)*($C14¡G$AY14<>""),COLUMN($C¡G$AY)),COUNTIF($C18¡GC18,C18))))
°}¦C¤½¦¡ ¥k©Ô¨ìAY19¶ñº¡(¦]¬°¤½¦¡¦³®M¥Î¦bµ{¦¡½X¤º¡A¨Æ«e¤£ª¾²Ä18¦C¼Æ¦rªºÅã¥Ü¨´¤î®æ¡A©Ò¥H¹w©Ô¨ìAY19)¡A
§YC19=
·í$C14¡G$AY14ªº¬YÀx¦s®æ<>""¥B$C14¡G$AY14=C18®É¡A
«hC19Åã¥Ü²Ä14¦C¸ÓÄ檺²Ä1¦C¦PÄæÈ¡F
¥t·í²Ä18¦C¦³2®æ¥H¤Wªº¬Û¦PȮɡA«h¸Ó²Ä19¦CªºÈ¥H¥Ñ¤j¦Ó¤p±Æ§Ç¡C
¸Ô¦pªþ¥ó :
TEST_1008.rar (3.54 KB)
½Ð°Ý¡G±zªºC19¤½¦¡·|¦p¦ó§@¸Ñ¡H
ÁÂÁ±z
|
|