move a row of data values to a column in sorted order

  • Thread starter moving row data to a column in a sorted
  • Start date
M

moving row data to a column in a sorted

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
 
M

Mike H

Hi,

88 - C

Is that all in one cell?
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
M

Max

Engage all the responders in your identical thread a couple of days ago,
instead of re-posting here:

http://tinyurl.com/ye37jpg

My response there shows a generic formulas way to carve the ascending order
results out even if there are ties in the row data
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top