Need help Sorting data

[Guest]

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!

 

[Myrna Larson]

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.

 

[Biff]

Hi!

Didn't you mean this: (array entered)

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

Biff