I have 9 cells H31:P31 the results of previous calculations. They will
always be in random order of value. In cells H35:P35 I want to get them
to arrange them in ascending order.

Any suggestions how I should do this?

TIA

Sam.

Try this:

Entered in H35 and copied across to P35.

=SMALL($H31:$P31,COLUMNS($H35:H35))

--
Biff
Microsoft Excel MVP


"Samuel" wrote in message
...
I have 9 cells H31:P31 the results of previous calculations. They will
always be in random order of value. In cells H35:P35 I want to get them
to arrange them in ascending order.

Any suggestions how I should do this?

TIA

Sam.

Hi,

Try this in H35 and copy it to the right

=SMALL($H31:$P31,COLUMN())

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Samuel" wrote:

I have 9 cells H31:P31 the results of previous calculations. They will
always be in random order of value. In cells H35:P35 I want to get them
to arrange them in ascending order.

Any suggestions how I should do this?

TIA

Sam.

Actually is should have read:

=SMALL($H31:$P31,COLUMN(A1))

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Samuel" wrote:

I have 9 cells H31:P31 the results of previous calculations. They will
always be in random order of value. In cells H35:P35 I want to get them
to arrange them in ascending order.

Any suggestions how I should do this?

TIA

Sam.

You should include a warning of the potential danger of using that formula.

--
Biff
Microsoft Excel MVP


"Shane Devenshire" wrote in
message ...
Actually is should have read:

=SMALL($H31:$P31,COLUMN(A1))

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Samuel" wrote:

I have 9 cells H31:P31 the results of previous calculations. They will
always be in random order of value. In cells H35:P35 I want to get them
to arrange them in ascending order.

Any suggestions how I should do this?

TIA

Sam.