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

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.


"moving row data to a column in a sorted" wrote:

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

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

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
--
Max
Singapore
---
"moving row data to a column in a sorted" wrote:
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. Example...

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