concrete sum

[belimbor]

Hi all

I need some help. I have number data in excel 2010. Need formula or format which will highlight or return numbers that together equals concrete number

for example, I have data:

10
20
15
30
100

problem which numbers sum is equal to 50? formula or format will highlight 20 and 30

Thanks and sorry for my English

 

[VoG]

This may help you Combination of numbers that sum or match a target value

 

[belimbor]

I have found this: Daily Dose of Excel » Blog Archive » Which Numbers Sum to Target

thanks VoG