如题所述
æ¯å¦æ°æ®å¨AB两åï¼Aå¤Bå°ï¼æ°æ®ä»ç¬¬äºè¡å¼å§
c2è¾å ¥
=if(countif(a:a,b2)<>0,b2,"")
å ¬å¼ä¸æ
Cåæ¾ç¤ºçå°±æ¯ä¸¤åç¸åçæ°æ®