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.