Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I have two columns of numbers, that I need to sort into one column. They are not sequential and some of the same numbers appear in each column. In the resulting column I need all the numbers listed in ascending order without duplication. The first column will range from 1 to 120 but not with all the numbers in the list from 1 to 120. (some numbers will be missing). The second column may have duplications of the first column, but with some unique numbers. eg (short list) 1 1 5 5 13 16 16 19 19 34 21 37 24 49 29 50 33 51 36 54 37 60 39 72 40 85 42 102 50 51 54 60 61 65 66 69 70 How can I sort these using functions. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to Synchronize data frm svrl workbooks & columns to 1 workbo | Excel Discussion (Misc queries) | |||
sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
Filtering Text Data from Multiple columns | Excel Worksheet Functions |