Is there are formula to sort?

[jaedmar]

Rather than having to select a range then clicking to sort, is there a formula that would sort a column as the calculations are done?

 

[jasonb75]

See post #3 http://www.mrexcel.com/forum/showthread.php?t=543818

 

[jaedmar]

Thanks,
So, no way to just do in a formula rather than macro, I guess?
Ed

 

[T. Valko]

Thanks,
So, no way to just do in a formula rather than macro, I guess?
Ed

Need more info.

What do you want to sort?

 

[Smitty]

So, no way to just do in a formula rather than macro, I guess?

You guess correct. A formula can't make physical changes to a worksheet, it can only return a result. In this case VBA is your only option, but once you get the hang of it you'll wonder how you ever did without it.

 

[shg]

You can do the equivalent of sorting with formulas, it just takes a lot of them. How many rows do you need to sort?

 

[jaedmar]

150 rows.

 

[shg]

Please describe your data, layout, and desired results, so we don't have to guess or ask 20 questions.