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

[µo°Ý] ½Ð°Ý ¦p¦ó¨Ï¥Î¤½¦¡±N°Ñ·Ó¤§­È±a¤J

[µo°Ý] ½Ð°Ý ¦p¦ó¨Ï¥Î¤½¦¡±N°Ñ·Ó¤§­È±a¤J

[attach]21670[/attach]
¦p¹Ï ½Ð°Ýµµ¦â¤§ªÅ®æ¸Ó¦p¦ó¿é¤JEXCELL¤§¤½¦¡ ¤~¯à±o¨ì³Ì±µªñ¤§¹ïÀ³­È
ÁÂÁ±zªº¥Î¤ß»P°Ñ»P




test1.zip (7.02 KB)

test.jpg (120.81 KB)

test.jpg

B4=VLOOKUP(B3,F:G,2) ¥i¥H³¡¤À¹F¦¨©Ò­nªº¹ïÀ³­È(¦ý¥u¾A¥Î©ó¹ïÀ³°Ïªº¼Æ­È»Ý­n¬O¥Ñ¤pÅܤj) ¦]¬°³o¥u¬O³¡¤ÀªºÁY¼v ¥Ñ©ó¬°°t¦X­ì©lµ{¦¡ ¬G¤£¯à§ïÅÜC D E F G ¤§­ì©l¤è¦¡ ©Ò¥H³Â·Ð¤j®a±Ð¾É§Ú

TOP

¦^´_ 1# lcctno

B2 {=MAX(IF(IF({1,0},ABS(D2:D108-B1),ABS(G2:G108-B1))=MIN(ABS(D2:D108-B1),ABS(G2:G108-B1)),IF({1,0},C2:D108,F2:F108)))}
B4 {=MAX(IF(IF({1,0},ABS(C2:C108-B3),ABS(F2:F108-B3))=MIN(ABS(C2:C108-B3),ABS(F2:F108-B3)),IF({1,0},D2:D108,G2:G108)))}


{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# ML089

³o¼Ë¬OOK¥i¦æªº ¤]·PÁ±zªº«ü¾É ¦ý§Ú¬ã¨s¤F±zªº¤º®e ÁÙ¬O¤£ª¾¹D¤º²[¬O¤°»ò ¥i§_½Ð±z¸Ô²Óªº»¡©ú±zªº¤º®e ¦b¦¹¥ýÁÂÁ±z¤F

TOP

¦^´_ 4# lcctno

B2 {=MAX(IF(IF({1,0},ABS(D2:D108-B1),ABS(G2:G108-B1))=MIN(ABS(D2:D108-B1),ABS(G2:G108-B1)),IF({1,0},C2:D108,F2:F108)))}

¤½¦¡¤j·N:  =MAX(if( ½d³òA=³Ì¤p®t­È, ½d³òB))

IF({1,0}, ¸ê®Æ1, ¸ê®Æ2)
±N2­Ó½d³ò(107*1)¦X¬°1­Ó½d³ò(107*2) : ³o¥u¬OÁY´î¤½¦¡ªø«×ªº¤@ºØ§Þ¥©

MIN(ABS(D2:D108-B1),ABS(G2:G108-B1))
§ä¥X³Ì¤p®t­È

¤£ÁY´î¤½¦¡¦p¤U =MAX(¤ñ¸û¸ê®Æ1, ¤ñ¸û¸ê®Æ2)
B2 {=MAX(IF(ABS(D2:D108-B1)=MIN(ABS(D2:D108-B1),ABS(G2:G108-B1)), C2:D108),  IF(ABS(G2:G108-B1)=MIN(ABS(D2:D108-B1),ABS(G2:G108-B1)), F2:F108))}
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : §g¤l¬°¥Ø¼Ð¡A¤p¤H¬°¥Øªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD