Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have two columns of numbers. One is a large list with say 3,000
random serial numbers. The other is a smaller list of 800 serial numbers. I want to find if any serial numbers are listed in both of the columns. I want to identify which number appear in both columns and move them to another column, or at least highlight them. I tried to follow the advice given to an earlier post but could not make it work for me: perhaps I need a simpler or more detailed explanation. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Listing Common Symbols Of 2 Columns | Excel Discussion (Misc queries) | |||
Add numbers accross columns after stripping away text | Excel Discussion (Misc queries) | |||
Columns in Excel are numbers instead of letters, how do I change . | Excel Discussion (Misc queries) | |||
In Excel can you merge two columns i.e. street numbers and addres. | Excel Worksheet Functions | |||
how to build a formula to match numbers in 2 columns with the equ. | Excel Worksheet Functions |