| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find values over a certain amount
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find values over a certain amount
On Thu, 20 Sep 2007 16:02:25 -0000, Captain Snuggles wrote:
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? 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)+I F(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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find values over a certain amount
Maybe,
=IF(COUNTIF(B2:G2,"=250")=2,TRUE,FALSE) Mike "Captain Snuggles" wrote: 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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find values over a certain amount
On Sep 20, 9:11 am, Boris wrote:
On Thu, 20 Sep 2007 16:02:25 -0000, Captain Snuggles wrote: 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? 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)+I F(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. Thanks, that worked beautifully! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find amount in row. | Excel Worksheet Functions | |||
| Find the smallest amount | Excel Discussion (Misc queries) | |||
| Find a cummulative amount | Excel Discussion (Misc queries) | |||
| find values that add up to certain amount | Excel Discussion (Misc queries) | |||
| find same amount in different workbooks | Excel Worksheet Functions | |||
Linear Mode
