Need help with a sumproduct or array formula

[Arjen Bakker]

Hello everyone

my name is Arjen and I'm new here.
I'm working with a set of data:

A smaller example:

Column A: Date
Column B: Employee
Column C: Revenue

Now it's no big deal to figure out the revenue per employee and date.
But the groups the employees belong to is not in the database and I do not want to
blow up the file by adding columns with data.
So I need to do it via lookup or index match but do not know how, if it is possible at all ...

Thanks in advance for your help !
Arjen

 

[PaddyD]

Hi - welcome to the board.

Sounds do-able in principle.

Unless your file is enormous, adding a single column of data to it shouldn't be too much of an issue.

But first, you need to give us more info:

"But the groups the employees belong to is not in the database..."

Where is it, then? Post back with more details please...

 

[Arjen Bakker]

Hello and thanks for the quick reply (here it is 2:30 AM)

Each employee belongs to a group and is easy to lookup in another Tab, call it "Group".
Like this:
Empl. A Group 1
Empl. B Group 1
Empl. C Group 2
Empl. D Group 2

In fact there are several hierarchies / levels of groups with different reporting structures.
So it doesn't stay with one column of 30.000 rows (which must be also formulas because of
varying requests)

I prepared a file but am not yet allowed to post it.


Thanks again ... Arjen

Hi - welcome to the board.

Sounds do-able in principle.

Unless your file is enormous, adding a single column of data to it shouldn't be too much of an issue.

But first, you need to give us more info:

"But the groups the employees belong to is not in the database..."

Where is it, then? Post back with more details please...