Thread: find all employees whose total salaries equal a given amount
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
atmbonda
 
Posts: n/a
Default find all employees whose total salaries equal a given amount
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

Reply With QuoteReply With Quote