把两张表都倒入ACCESS新建数据库中,然后为它们建关系,比如相同的ID之类的,关系中合并的就有不同的选项,其中有一项就可以选掉重复项。
Farewell to six years in primary school,morning and night get along with you - blessed with the feelings of excitement and novelty,towards the overseas Chinese in the palace of the knowledge,started the nervous and orderly junior middle school three year study life.Walk in the first corner of life,you is what feeling?Is looking forward to,happy; Still vacant,lost? Have such a story:in Africa,antelope every morning opened his eyes,think the first thing is,I have to run faster,otherwise,I will be eaten by a lion.And at the same time,the lion awoke from his sleep,the first flash in your mind a thought is that I have to run faster to catch up with more antelope,otherwise I will starve to death.So,almost at the same time,the antelope and the lion jump and meet
重新在一列中输入=if(A3<50," ",A3),然后粘贴下,选择只有值,搞定。
可以设置筛选条件 然后删除