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

½Ð±Ð¤j¤j­Ì¤@±ø¨ç¼Æ,

½Ð±Ð¤j¤j­Ì¤@±ø¨ç¼Æ,

½Ð±Ð¤j¤j­Ì¤@±ø¨ç¼Æ,
¤u§@ªí1
aÄæ¬O½s¸¹,  jÄæ¬O©m¦W,

¤u§@ªí2
aÄæ¬O½s¸¹, dÄæ¬O©m¦W, eÄæ¬O¦a§},

²{¥Î®a·Q«ö¤u§@ªí1aÄæ¦ì½s¸¹, jÄæ©m¦W, °Ñ·Ó¤u§@ªí2, aÄæ¬O½s¸¹, dÄæ¬O©m¦W,, ²Å¦X¥H¤W¨âµ§¸ê®Æ¶Ç¦^¤u§@ªí2¦a§}©ó¤u§@ªí1oÄæ,
½Ð°Ý¤j¤j­Ì³o¨ç¼Æ¦p¦ó¼g,
ÁÂÁÂ!!
hong912

¦^´_ 1# hong912
¤u§@ªí1¤§Àx¦s®æO2¿é¤J
=IFERROR(INDEX(¤u§@ªí2!E:E,MATCH(I2,¤u§@ªí2!D:D,0)),"")
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 2# p212

·PÁ¤j¤j¦^À³,
¤£ª¾¨ç¼Æ¥i§_¯à°£°Ñ·Ó¤u§@ªí2©m¦WÄæ¥~, §Æ±æ¯à°Ñ·Ó®I½s¸¹Äæ, ²{§âÀɮפW¶Ç, ¤º¦³»¡©ú, ¥ý¦æÁÂÁÂ!!
¬¡­¶Ã¯1.rar (8.42 KB)

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-12-16 10:29 ½s¿è

¦^´_ 3# ©P¤j°¶
¡u¦h±ø¥óªº¬d¸ß¡v¨Ï¥Î©w¸q¦WºÙ»P°}¦C¤½¦¡¸Ñ¨M¡A½Ð°Ñ¨£ªþ¥ó¡C
»¡©ú¡G
©w¸q¦WºÙ¡u½s¸¹¡v¡A°Ñ·Ó¨ì¿é¤J=OFFSET(¤u§@ªí2!$A$2,,,COUNTA(¤u§@ªí2!$A:$A)-1)¡C
©w¸q¦WºÙ¡u©m¦W¡v¡A°Ñ·Ó¨ì¿é¤J=OFFSET(¤u§@ªí2!$D$2,,,COUNTA(¤u§@ªí2!$D:$D)-1)¡C
©w¸q¦WºÙ¡u¦a§}¡v¡A°Ñ·Ó¨ì¿é¤J=OFFSET(¤u§@ªí2!$E$2,,,COUNTA(¤u§@ªí2!$E:$E)-1)¡C
¤u§@ªí1¤§Àx¦s®æO2¿é¤J°}¦C¤½¦¡ (¥HCtrl+Shift+Enter¿é¤J)
=IF(J2="","",IFERROR(INDEX(¦a§},MATCH(1,(½s¸¹=A2)*(©m¦W=J2),0)),""))
¦V¤U½Æ»s¤½¦¡
(½s¸¹=A2)*(©m¦W=J2)±ø¥ó§¹¥þ¦¨¥ß®É·|¶Ç¦^ True (¹Bºâ®Éµø¬°1)¡A¤Ï¤§¶Ç¦^ False (¹Bºâ®Éµø¬°0)¡C

¬¡­¶Ã¯2.zip (8.98 KB)

TOP

±`±`³£¤£À´¨Ï¥ÎOFFSET... ¨ä¹êÀ³¸Ó­n¦b¨ººØ±¡ªp¤U¤~¨Ï¥Î©O...

TOP

¦^´_ 4# p212
·PÁ¤j¤j,
­ì¨Ó¦WºÙ¬O¥i¥H³o¼Ë¥Î, ,
³Ì«á¯¬¤j¤j¸t½Ï§Ö¼Ö, ¨­Åé°·±d, ÁÂÁÂ!

TOP

        ÀR«ä¦Û¦b : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD