Need Further Help Sorting Data

[monkeytrader]

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.29
2 1.26 3.28
3 0.54 0.84
4 0.99 0.07
....

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". (The list of data I want to sort through is roughly 1,000 rows)

Thanks again for your help in advance!

 

[Steve]

Didn't Myrna answer this already?

 

[monkeytrader]

yes, but I needed to clarify my question. To clarify, I want to see any data
from column A that is greater than or equal to 0.50 printed in column B.
ex)
A B C
1 0.25
2 1.54
3 0.89
4 0.49
5 0.11
6 2.22
7 0.50
8 0.17

So, I would like "B1" to show nothing, but "B2" to show "1.54"... "B3" to
show "0.89", but "B4" to be blank...etc, etc...

Don't know if there is an excel function to do this, but hope someone can
help...

Thanks again. Apologize for the repost...

 

[Biff]

Hi!

That's a lot different from your previous post!

In B1 enter this formula and copy cown as needed:

=IF(A1>=0.5,A1,"")

Biff

 

[monkeytrader]

thanks all!!! what a difference asking the right question makes!...