Arrange results in ascending order accross a row

[Samuel]

I have 9 cells H3131 the results of previous calculations. They will
always be in random order of value. In cells H3535 I want to get them
to arrange them in ascending order.

Any suggestions how I should do this?

TIA

Sam.

 

[T. Valko]

Try this:

Entered in H35 and copied across to P35.

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

 

[Shane Devenshire]

Hi,

Try this in H35 and copy it to the right

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

 

[Shane Devenshire]

Actually is should have read:

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

 

[T. Valko]

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