Hello,
I have an excel with a lot of data (attached excel is just a small portion of it).
In this excel, my primary objective is to find the EFFORT by each RESOURCE to each PROJECT.
If i use SUMIF, i get the total effort for each resource easily.
However, I want to know list the PROJECTS and respective EFFORT for each RESOURCE (if effort for a particular PROJECT has zero EFFORT by an associate, then that project need not be listed)
Below is the sample of the data I have. Full sheet has too many values like this (one more reason why i don't want the PROJECT that zero EFFORT by an associate need not be listed)
For some reason, i am unable to attache the file. Thanks in advance for your time.
<tbody>
</tbody>
I have an excel with a lot of data (attached excel is just a small portion of it).
In this excel, my primary objective is to find the EFFORT by each RESOURCE to each PROJECT.
If i use SUMIF, i get the total effort for each resource easily.
However, I want to know list the PROJECTS and respective EFFORT for each RESOURCE (if effort for a particular PROJECT has zero EFFORT by an associate, then that project need not be listed)
Below is the sample of the data I have. Full sheet has too many values like this (one more reason why i don't want the PROJECT that zero EFFORT by an associate need not be listed)
For some reason, i am unable to attache the file. Thanks in advance for your time.
Task | Project | Priority | Resource | Status | Effort |
CAD | P-01234 | Medium | Ramesh | In Progress | |
CAD | P-01235 | Low | Krish | In Progress | |
CAD | P-01236 | Medium | Mani | Completed | 3 |
CAD | P-01237 | High | Mani | In Progress | 3 |
CAD | P-01238 | Medium | Mani | In Progress | |
CAD | P-01239 | Medium | Mani | In Progress | 3 |
Design | P-01240 | Medium | Mani | In Progress | 4 |
CAD | P-01250 | Medium | Mani | In Progress | |
Report | P-01251 | Medium | Mani | Completed | 12 |
Design | P-01252 | Medium | Mani | In Progress | 34 |
Report | P-01253 | Low | Krish | In Progress | 45 |
CAD | P-01239 | Medium | Mani | On Hold | |
CAD | P-01240 | High | Mani | Completed | 34 |
Report | P-01247 | High | Mor | Completed | |
Report | P-01248 | Medium | Mor | In Progress | 6 |
Design | P-01249 | Medium | Mor | In Progress | |
CAD | P-01250 | High | Mor | In Progress | 99 |
CAD | P-01251 | Medium | Mor | In Progress | 1 |
CAD | P-01252 | High | Mor | Completed | 2 |
CAD | P-01253 | Low | Krish | In Progress | 23 |
CAD | P-01254 | Medium | Krish | On Hold | 34 |
Design | P-01255 | Medium | Ramesh | Completed | 45 |
Report | P-01256 | High | Mor | In Progress | 34 |
Design | P-01257 | Medium | Mani | Completed | |
Report | P-01237 | Medium | Ramesh | Completed | 23 |
CAD | P-01238 | Medium | Mor | Completed | |
CAD | P-01239 | High | Bari | Completed | 8 |
CAD | P-01250 | Medium | Bari | Completed | |
CAD | P-01251 | Medium | Bari | Completed | 23 |
CAD | P-01252 | Medium | Suba | In Progress | 2 |
Design | P-01253 | Medium | Suba | In Progress | |
Report | P-01265 | Medium | Suba | In Progress | 4 |
Design | P-01265 | Medium | Suba | In Progress | 5 |
CAD | P-01265 | Medium | Suba | In Progress | 4 |
<tbody>
</tbody>
Last edited: