Find values over a certain amount

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Captain Snuggles - 20 Sep 2007 17:02 GMT

I need to find a way to identify all the people who have a dollar
amount of 250 or more in two of five columns.

Name Amount1 Amount2 Amount3
Amount4 Amount5 True/False
John Doe 300 0 100
5000 0 True
Mary Yu 90 100 100
100 50 False

Any ideas?

Reply to this Message

Boris - 20 Sep 2007 17:11 GMT

> I need to find a way to identify all the people who have a dollar
> amount of 250 or more in two of five columns.
[quoted text clipped - 7 lines]
>
> Any ideas?

How about adding an extra column with sum of the results? Something like
this:
=IF(B2>=250,1,0)+IF(C2>=250,1,0)+IF(D2>=250,1,0)+IF(E2>=250,1,0)+IF(F2>=250,1,0)
Then, you can test for value equal or greater than 2 in that column...

Regards,

B.

Reply to this Message

Captain Snuggles - 20 Sep 2007 17:34 GMT

> > I need to find a way to identify all the people who have a dollar
> > amount of 250 or more in two of five columns.
[quoted text clipped - 16 lines]
>
> B.

Thanks, that worked beautifully!

Reply to this Message

Dave - 20 Sep 2007 17:18 GMT

Maybe,

=IF(COUNTIF(B2:G2,">=250")>=2,TRUE,FALSE)

Mike

> I need to find a way to identify all the people who have a dollar
> amount of 250 or more in two of five columns.
[quoted text clipped - 7 lines]
>
> Any ideas?

Reply to this Message