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