I think that my work Jaleel. I will try it and let you know

"Jaleel" wrote:

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


"dick" wrote:

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
"ice" wrote:

do you have in the first column the summary of both?

"dick" wrote:

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?