You need the solver add-in for this

"put the data set in let's say A2:A8, in B2:B8 put a set of ones {1,1,1 etc}
in the adjacent cells
in C2 put 8, in D2 put

=SUMPRODUCT(A2:A7,B2:B7)


select D2 and do toolssolver, set target cell $D$2 (should come up
automatically if selected)


Equal to a Value of 8, by changing cells $B$2:$B$7, click add under Subject
to the constraints of:
in Cell reference put


$B$2:$B$7


from dropdown select Bin, click OK and click Solve, Keep solver solution
and look at the table


2 1
4 0
5 0
6 1
9 0
13 0


there you can see that 4 ones have been replaced by zeros and the adjacent
cells to the 2 ones total 8 "



adapt to fit


--


Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"atmbonda" wrote in message
...
Hello,

I have a large data file in 2 columns:
1st column = Employee ID
2nd Column = Salary

I want to find combinations of salaries whose total equals a certain
amount
and identify those employees. Please any suggestions on how should I
proceed?
What formula to use?

Thanks for your assistance.

al