excel中a列怎么筛选b列

1.EXCEL表中,如果A列包含B列的值,如何在C列中体现出来

使用excel宏可以实现如上功能！

sub check()

dim numa as integer //A列行数

dim numb as integer//B列行数

dim num as integer

numa=50

numb=50

num=1

for i=1 to numa

for j=1 to numb

if sheet1.cells(1,i).value==sheet1.cells(2,j) then

shee1.cells(3,num)=sheet1.cells(1,i)

num=num+1

end if

next j

next i

end sub