columns of numbers
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?
|