How to sort duplicate numbers

[sricomm]

Dear All

Please help me to solve this ..

Column

A1 B1 C1 D1
1 2 3 4


Column
A3 B3 C3 D3
1 3 4 5


i need help on how at column A5 B5 C5 D5 E5 ( output ) can generate the result

A5 B5 C5 D5 E5
1 2 3 4 5

Any duplicate numbers will be sort just once .

Appreciate any help from our members ..

thanks

[Paul]

A few questions..

Are your ranges always A1:D1 and A3:D3, and your output range always A5:E5 (or larger, depending on the values in the previous ranges)? I know you were trying to provide an example, but I'm guessing that any solution we come up with based on that example will fall short if you have more data in other cells/rows/columns.

[sricomm]

A few questions..

Are your ranges always A1:D1 and A3:D3, and your output range always A5:E5 (or larger, depending on the values in the previous ranges)? I know you were trying to provide an example, but I'm guessing that any solution we come up with based on that example will fall short if you have more data in other cells/rows/columns.

hi mate ..

the column range are just an example ... it can be any column .. the important result is to get the sort number ..

any duplicate numbers will only display a single number

please help .. thanks