Quote:
Originally Posted by aagrawal
Hello,
I have never used this funtion before. Not sure if this is even the right one. But here is what I am trying to do.
I have data on one worksheet (say deposits). The payee names, their job titles and payout amounts are on this worksheet. I have another worksheet which maps the job titles to the department of the payee.
I need a way to report payouts by department.
Any assistance is greatly appreciated.
Regards
Me
|
Hi Me,
Could you post an example workbook with dummy data that represents what you're trying to acheive?
If you manually input a few of the results you're looking to get with a few brief notes that explain where they come from, if not immediately obvious, it will make it much easier to provide you with a solution.
Cheers.
S.