columns of numbers

D

dick

I have 2 columns of numbers. The first column has all the numbers of the
second column and more.
Do you know how I can eliminate those extra numbers from the first column
so that I only have those of the second column remaining?
 
D

dick

Yes. These are part numbers and they have letters in them.
All the numbers in the second column are in the first column but notvi
vice versa
 
J

Jaleel

Hi,

Select both the columns. Go to the Menu, Data – Filter – AutoFilter. From
the drop down arrow of the second column, select (Blanks). Now select the
entire rows by clicking the gray number part of Excel. Go to the Menu, Edit
– Go To – Special and select Visible cells only and delete the entire rows.
Go to the arrow of the second column and select (All). Try it.

Regards,

Jaleel
 
Top