find all employees whose total salaries equal a given amount
Just to be clear, you want one or more combinations of salaries which add up to exactly a given amount. You are not looking for
salaries which exceed a given threshhold, or when combined exceed a given threshhold or something like that? Sometimes the question
is worded such that the solution for the problem, as stated, is much more complicated than is what the person actually was looking
for. Miscommunication is a big player in the NGs. Believe me, I've miscommunicated lots of problems and I've caused much more brains
cells to be expended than were due.
Richard
--
RMC,CPA
"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
|