View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brian Brian is offline
external usenet poster
 
Posts: 683
Default Formula listing words that meet criteria

Is there a formula that will allow you to search for amount criteria and list
the words that meet that criteria?

For example, I have the following data in columns A, B & C:

$1,000,000 5% Prime Fund
$3,000,000 1% Treasury Bill
$500,000 4% Money Market Fund
$2,000,000 5% Prime Fund

I'd like to possibly write a concatenate formula that will tell me what
investments have a balance greater than $750,000
Ideally I'd like the answer in the cell to be "Prime Fund, Treasury Bill"
I realize I can't use VLookup because it only finds the first answer that
meets the criteria....and I also want to prevent the formula for giving two
of the same answers (using the example above, I don't want the answer to be
"Prime Fund, Treasury Bill, Prime Fund"

Is this possible using some Excel fomulas?