Forum Discussion
Solved
Help with a process / formula(s) to look up variable values and return the data
Dear Excel Community, I was wondering if you could advise or give some guidance with a problem i have and what the best solution would be ? Please see attached Workbook. In the Data sheet, we...
Thank you for previously supplying me with a solution to my problem. I'm wondering if you could help me tweak the formula based on the attached workbook.
Essentially i want to solve the same issue as previously highlighted although this time i want to be able to group by teams and the array needs to cover multiple months.
For example, In the analysis sheet, there are 4 teams. Essentially i want the formula to look across the 3 months, and populate a list of unique requesters, the no of requests and total amount spent against their team in the analysis tab.
Hope that makes sense ?
Thanking you in advance for you help.
Raj