H2:K16{=VLOOKUP(COUNTIF($H$1:$H2,$H2)&$H2,IF({1,0},COUNTIF(OFFSET($A$2,,,ROW($1:$15)),$A$2:$A$16)&$A$2:$A$16,D$2:D$16),2,)
另解{=--MID(VLOOKUP(COUNTIF($H$1:$H2,$H2)&$H2,COUNTIF(OFFSET($A$2,,,ROW($1:$15)),$A$2:$A$16)&$A$2:$F$16,COLUMN(D1),),2,99)
另解{=VLOOKUP(1=1,IF({1,0},COUNTIF(OFFSET($A$2,,,ROW($1:$15)),$A$2:$A$16)*($H2=$A$2:$A$16)>=COUNTIF($H$1:$H2,$H2),D$2:D$16),2,)
留言
張貼留言