Need Further Help Sorting Data

M

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!
 
M

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...
 
B

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
 
Top