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

°ª¤â¤j¤j½Ð±Ð¦p¦ó¥ÎVB±N¤@°ïdataÂনªí®æ,ÁÂÁÂ

°ª¤â¤j¤j½Ð±Ð¦p¦ó¥ÎVB±N¤@°ïdataÂনªí®æ,ÁÂÁÂ

°ª¤â¤j¤j½Ð±Ð¦p¦ó¥ÎVB±N¤@°ïdataÂনªí®æ?ÁÂÁÂ
table.zip (16.78 KB)

TOP

C6=B6&""

C10:C34=IF(A10="¼Ó",IFERROR(LOOKUP(1,0/(B$4:B4=B8)/(B$5:B5=B9),C$6:C6),"")&B10&CHAR(10),"")

J4:N4=LOOKUP(1,0/($B4:$B32=J2)/($B5:$B33=J3),$C6:$C34)

5152.png (14.48 KB)

5152.png

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD