[MS Excel]Search and mark items with a sum at a particular amount?

[MS Excel]

How do I search and mark items with a sum at a particular amount,

i.e., among 1,000 transactions, find out the transactions which add up together will result in exact $10,000,000?

Thanks.