God morning everyone,

In column D (d15:d20) I have some data - fixed values (numbers)
In Colum BL(BL10:BL5000) I have some other data - calculated values (numbers)
I want to order these data in one colum based on their values. (No Macro) as
follow:

D BL New Colum
2 2 2
8 3 3
6 6
9 8
15 9
20 15
22 20
22

Data might be ordered in a new colum or the data from D colum can be added
to those of BL colum.

TIA
Tim

I dont know why, but the data in the columns ia totally mixed up. This
posting window doesent let me post tables or any screenshot. So please ignore
what you see in columns and try to imagine the problem by what I explained.

Thank you again
Tim

"Tim" wrote:

God morning everyone,

In column D (d15:d20) I have some data - fixed values (numbers)
In Colum BL(BL10:BL5000) I have some other data - calculated values (numbers)
I want to order these data in one colum based on their values. (No Macro) as
follow:

D BL New Colum
2 2 2
8 3 3
6 6
9 8
15 9
20 15
22 20
22

Data might be ordered in a new colum or the data from D colum can be added
to those of BL colum.

TIA
Tim