ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

²Å¦X2Äæ³Ì¤j­È¡A¨Ã±a¥X¸Ó¦C¸ê®Æ

²Å¦X2Äæ³Ì¤j­È¡A¨Ã±a¥X¸Ó¦C¸ê®Æ

³Ìªñ§Ú¦³¼g1¤½¦¡¡A¬O¥i¥H¬d¸ÓÄæ³Ì¤j­È«á¡A±a¥X¸Ó¦C¸ê®Æ

¥u¬O§Ú·Q­n¦A§ï¦¨"²Å¦X2Äæ³Ì¤j­È¡A¨Ã±a¥X¸Ó¦C¸ê®Æ"¡A½Ð°Ý¦U¦ì¤½¦¡¦p¦ó­×§ï¡A·PÁ«ü±Ð
1060816§ì³Ì¤j­È¨Ã±a¥X¸Ó¦C¸ê®Æ.zip (6.64 KB)

¥»©«³Ì«á¥Ñ p212 ©ó 2017-8-30 11:50 ½s¿è

¦^´_ 1# rph
ªþÀɦn¹³¤W¶Ç¥¢±Ñ¡A¥i¥H¦A¤W¶Ç¤@¦¸¡H
ÁÂÁ¡I

TOP

²Å¦X²Ä2Äæ³Ì¤j­È »P  ²Ä3Äæ³Ì¤j­È IF¤£¦P¦C®É­n¦óªÌÀu¥ý????
ù

TOP

¦^´_ 2# p212

1060816§ì³Ì¤j­È¨Ã±a¥X¸Ó¦C¸ê®Æ.zip (6.64 KB)

§Ú¤w­«·s¤W¶Ç¡A·PÁÂ

TOP

¦^´_ 4# rph
ÁÙ¬OµLªk¶}±Ò¤U¸ü¡I
¥i¥HºI¨úµe­±¨Ñ°Ñ¡H
ÁÂÁ¡I

TOP

¦^´_ 5# p212

TOP

¦^´_ 3# rouber590324

±ø¥ó¥²¶·¬O¦P¤@¦C¡A³o¼Ë¤£ª¾¦æªº³q¶Ü???·PÁÂ

TOP

¦pªG¤@©w·|¦P¤@¦C.¥Î§A­ì¨Ó¤½¦¡¤£´NOK(¤Ï¥¿¦p§A»¡³Ì¤j­È¤@©w·|¦P¤@¦C)

³Ìªñ§Ú¦³¼g1¤½¦¡¡A¬O¥i¥H¬d¸ÓÄæ³Ì¤j­È«á¡A±a¥X¸Ó¦C¸ê®Æ
ù

TOP

¦^´_ 1# rph


    ¦pªG§Aªº»Ý¨D¥i¥H´y­z±o§ó¨ãÅéÂI¡A
¡@¤]³\§Ú¥i¥HÀ°§U§A¡ã¡@¡@: )

¡@¦pªG§A¥u¬O·Q­n§ä²Ä¤GÄæ»P²Ä¤TÄ椤³Ì¤jªº¼Æ­È¡A
¡@À³¸Ó¥u»Ý­n¡@=MAX(B2:C5)¡@³o¼Ë´Nµ²§ô¤F...
¡@¦ý§Úı±o§Aªº°ÝÃDÀ³¸Ó¨S³o»ò²³æ

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2017-9-18 19:13 ½s¿è

G1{=INDEX(A:A,RIGHT(MAX($B2:$B5/1%+ROW(B$2:B$5)),2))

G4{=IFERROR(INDEX(A:A,TEXT(MAX((RIGHT(MAX($B2:$B5/1%+ROW(B$2:B$5)),2)-RIGHT(MAX($C2:$C5/1%+ROW(B$2:B$5)),2)=0)*ROW(B$2:B$5)),"0;;!A")),"XXX")
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD