View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nils Nils is offline
external usenet poster
 
Posts: 7
Default Sort each line horizontally and separately

I have a worksheet with 200 lines. I would like to sort each line
horizontally, so that the lowest number in each line is represented in column
A, and the second lowest number in column B and so on. Can this be done for
all the lines at the same time?


Before sorting
A B C
Line 1 2 1 7
Line 2 5 8 1

After sorting
A B C
Line 1 1 2 7
Line 2 1 5 8
--
Best regards

Nils