Assuming this doesn't have to be dynamic, in C1 type this formula

=SMALL(A1:B4,ROW())

and copy it down until it returns an error value.


On Sun, 20 Feb 2005 15:51:03 -0800, monkeytrader
wrote:

Trying to figure out how to sort through some data and print it into a new
column.
ex)
A B C D
1 0.49 0.49
2 1.26 1.26
3 0.54 0.54
4 0.10 0.10

I would like to have column "C" show any data from columns "A" and "B" that
are greater than or equal to "0.50" and ignore any data that is less than
"0.49".

Thanks for your help in advance!