Need help Sorting data
 

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!

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!

Hi!

Didn't you mean this: (array entered)

=SMALL(IF(A$1:B$4=0.5,A$1:B$4),ROW(1:1))

Biff

-----Original Message-----
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!

.