Thread: move a row of data values to a column in sorted order
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
moving row data to a column in a sorted[_2_] moving row data to a column in a sorted[_2_] is offline
external usenet poster
  
Posts: 5
Default move a row of data values to a column in sorted order
Does anyone have a method of moving a row of random values to a separate
column on the speadsheet in numerical order and capturing the heading fields
sot that they are matched. Expample...

A B C D
232 121 88 412 --- this is my row data

column this is how I want to reformat the row data on the spreadsheet
88 - C
121 - B
232 - A
412 - D
Reply With QuoteReply With Quote