Ron

Got it figured out I can enter functions and close out. Any more tips
Scott

"Ron Rosenfeld" wrote:

On Thu, 8 Dec 2005 07:29:06 -0800, "scott"
wrote:

Is this even possible without recording a macro. I have a column with
setting's entered. say b4:b28. In this column diffrent chemical settings are
entered. You may start the day at 130 but during the course of the day this
may change. The changes are entered in the same column but diffrent row. What
I need is at the end of the day I want the settings to be arranged in the top
spots of a diffrent column. I really do not want to record a macro to sort if
I do not have to because I have multiply columns with different settings. I
want to skip the blank cells and have the cells with settings in at the top
of a seperate column. The cells between the settings are blank.

Thanks in adavance
Scott

Example Finish if possible
B4
183 183
134
120

134
120



etc to b28

1. Download and Install Longre's free morefunc.xll add-in from
http://xcell05.free.fr

2. Enter the array formula =VSORT(B4:B28) into the cells of your Result
column.

To enter this formula:
1. Select the target range (e.g. Z4:Z28)
2. Type or paste in =VSORT(B4:B28)
3. Hold down <ctrl<shift while hitting <enter. Excel will place
braces {...} around the formula and also enter the formula in every selected
cell.

Note that this formula, as written, is volatile so will update automatically as
you enter data.

Note also that the "blanks" will be displayed at the end so there is no need to
specifically test for them.




--ron