Need Further 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.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!

Didn't Myrna answer this already?


"monkeytrader" wrote in message
...
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!

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

"Steve" wrote:

Didn't Myrna answer this already?


"monkeytrader" wrote in message
...
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!

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

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

"Steve" wrote:

Didn't Myrna answer this already?


"monkeytrader"
wrote in message
news:4B4EE6AA-0C2A-4B2A-AFE3-
...
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!



.

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

"Biff" wrote:

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

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

"Steve" wrote:

Didn't Myrna answer this already?


"monkeytrader"
wrote in message
news:4B4EE6AA-0C2A-4B2A-AFE3-
...
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!



.