| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I compare tow columns of numbers? | Excel Discussion (Misc queries) | |||
| why are my columns labelled with numbers? | Excel Discussion (Misc queries) | |||
| Macro preparing numbers to be booked (columns to be chosen conditionally) | Excel Worksheet Functions | |||
| Columns are numbers, rows letters. How do I change back? | Setting up and Configuration of Excel | |||
| In Excel can you merge two columns i.e. street numbers and addres. | Excel Worksheet Functions | |||
Hybrid Mode
