columns of numbers
 

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?

columns of numbers
 

See this: http://www.cpearson.com/excel/duplic...gingDuplicates
--
Brevity is the soul of wit.


"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?

columns of numbers
 

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?

columns of numbers
 

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?

columns of numbers
 

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?

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?

columns of numbers
 

PLS write an example, so I can help you.
Only the first row.

"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?