LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Mcobra41
 
Posts: n/a
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel subtotals, add a sort option, and BOLD the function answers crescent97526 New Users to Excel 4 December 21st 05 04:30 PM
How do I filter or sort by cell shading? urnojfk Excel Discussion (Misc queries) 2 January 11th 05 04:05 PM
Excel Auto Filter: WHY'S SORT @ TOP OF LIST? WHEN I KEY TO "SHOW . Dan W Excel Worksheet Functions 0 December 1st 04 03:53 PM
The Auto Filter button lost the column specified option. D Excel Worksheet Functions 1 November 4th 04 11:47 PM
sort option is greyed out in excel mom Excel Worksheet Functions 1 November 3rd 04 03:22 PM


All times are GMT +1. The time now is 04:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"