View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tim Tim is offline
external usenet poster
 
Posts: 408
Default How to order several data from different rows in one row?

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.

D BL New Colum
2 2 2
8 3 3
15 6 6
20 9 8
15 9
22 15
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