Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Ok, I have a list of numbers in one column (14,000+) and I have a list in a
second column (12,000+) The numbers in the second column are equal to a number in the first column. I need to have a side by side comparison of the two lists. With a blank cell representing any number not on the second column that is on the first column. There are 2000 numbers missing in the second column and I would like to two columns to show side by side. Here is a basic example of what i am trying to do, 2145154 2145154 2140020 2140020 2098960 2098960 2115448 2115450 2115450 2140019 2140019 2149646 2147722 2147722 Basically I have been going in hand by hand and inserting a blank cell to push the cells down. Which I have to go through every number individually and with 14,000 numbers it has become quite a pain. I am wondering if their is some sort of filter or sort function that could place the numbers in the right column to be equal to their number in the left column? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel subtotals, add a sort option, and BOLD the function answers | New Users to Excel | |||
How do I filter or sort by cell shading? | Excel Discussion (Misc queries) | |||
Excel Auto Filter: WHY'S SORT @ TOP OF LIST? WHEN I KEY TO "SHOW . | Excel Worksheet Functions | |||
The Auto Filter button lost the column specified option. | Excel Worksheet Functions | |||
sort option is greyed out in excel | Excel Worksheet Functions |