Find which one will total a value

[calvinle]

Hi,

I have 10k line of row with amount.
Is it possible to find which one together will give me x amount?
Is that possible with Excel?

Thanks

[MrShorty]

Sounds like a typical "subset sum problem". In Excel, I usually expect an approach like this one: http://www.k2e.com/tech-update/tips/...specific-value