Sort or Filter option?
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?
|