Arrange results in ascending order accross a row

Samuel · Jul 31, 2009

I have 9 cells H31

31 the results of previous calculations. They will
always be in random order of value. In cells H35

35 I want to get them
to arrange them in ascending order.

Any suggestions how I should do this?

TIA

Sam.

T. Valko · Jul 31, 2009

Try this:

Entered in H35 and copied across to P35.

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

Shane Devenshire · Jul 31, 2009

Hi,

Try this in H35 and copy it to the right

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

Shane Devenshire · Jul 31, 2009

Actually is should have read:

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

T. Valko · Jul 31, 2009

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