Baluba
New Member
- Joined
- Sep 5, 2012
- Messages
- 7
Greetings exalted excel gurus. I have a problem which I've been trying to wrap my head around for the last hour, and any tips would be much appreciated.
I have a sheet of projects by department with corresponding revenue. The same project can be reoccuring within the same department with a different listing. It can also occur on a different department.
I would like to make a new sheet were I:
- List the projects only once pr. department, even though they appear several times in the original sheet. I will then do a sumifs on the project revenue given that department.
- The formula would need to check if the project has already been listed in this department before to avoid duplicates.
Example from original sheet:
<tbody>
</tbody><colgroup><col span="2"><col></colgroup>
Here I would ie, sum the two listing from the 3010759 project for dept. 431 for a total of 14,451 and another one for this project under dept. 440 for 56,481.
Any tips on how this could be achieved smoothly?
I have a sheet of projects by department with corresponding revenue. The same project can be reoccuring within the same department with a different listing. It can also occur on a different department.
I would like to make a new sheet were I:
- List the projects only once pr. department, even though they appear several times in the original sheet. I will then do a sumifs on the project revenue given that department.
- The formula would need to check if the project has already been listed in this department before to avoid duplicates.
Example from original sheet:
Department | Project No | NOK Amount |
431 | 3011454 | 142,003 |
431 | 3010759 | 11,658 |
431 | 3010759 | 2,793 |
440 | 3010759 | 56,481 |
<tbody>
</tbody><colgroup><col span="2"><col></colgroup>
Here I would ie, sum the two listing from the 3010759 project for dept. 431 for a total of 14,451 and another one for this project under dept. 440 for 56,481.
Any tips on how this could be achieved smoothly?