=ArrayFormula(IFERROR(OFFSET('¹w¬ù¸ê®Æ®w'!$B$1,SMALL(IF(¹w¬ù¹q¸Ü=$D3,ROW(¹w¬ù¤é´Á),""),
COLUMN('¹w¬ù¸ê®Æ®w'!A:A))-1,0),""))
¥H¤W¨ç¼Æ¦bªí®æ©¹¥k©Ô·|¥h¸ê®Æ§ì¸ê®Æ, ¦³¿ìªk§ï¦¨©¹¤U©Ô§ì¸ê®Æ¶Ü?
¹w¬ù¸ê®Æ®w
¹w¬ù¹q¸Ü ¹w¬ù¤é´Á
0912345789 2022/9/1 ¤W¤È 12:00:00
0912345789 2022/9/2 ¤W¤È 12:00:00
0912345789 2022/9/3 ¤W¤È 12:00:00
------------------------------------------ |