| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
compare and move numbers
I have two columns with 1000+ numbers in them. Column 1 is the correct
column. I want to compare columns 1 and 2 and move those in #2 that don't match or appear in #1 to a third column. End result should be #' 1 and 2 match and a third column contains #'s that were in #2 but didn't match #1. make any sense? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare a list of numbers | Excel Worksheet Functions | |||
| compare a list of numbers | Excel Worksheet Functions | |||
| VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
| how can i move the starting point for the numbers numbers down. | Setting up and Configuration of Excel | |||
| How to compare two cells for the same numbers | Excel Worksheet Functions | |||
Threaded Mode
