Hi Team,
I am looking for some help here, I have base data and need to get the unique info based on one criteria in the below example is is "Category".
Why I am looking formula is because it should dynamic and should not perform pivot/remove duplicate every time.
Base Data
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Require Output
<colgroup><col><col></colgroup><tbody>
</tbody>
Thank you,
I am looking for some help here, I have base data and need to get the unique info based on one criteria in the below example is is "Category".
Why I am looking formula is because it should dynamic and should not perform pivot/remove duplicate every time.
Base Data
Project | Category | Assigned To | Customer | Hours | Days |
Project 1 | Category 1 | Employee 1 | Cust 1 | 500 | 59 |
Project 3 | Category 1 | Employee 2 | Cust 1 | 500 | 59 |
Project 2 | Category 2 | Employee 4 | Cust 2 | 400 | 31 |
Project 4 | Category 2 | Employee 3 | Cust 2 | 400 | 31 |
Project 8 | Category 2 | Employee 1 | Cust 2 | 400 | 31 |
Project 5 | Category 3 | Employee 2 | Cust 3 | 300 | 39 |
Project 6 | Category 4 | Employee 4 | Cust 5 | 500 | 9 |
project 9 | Category 4 | Employee 1 | Cust 5 | 500 | 9 |
Project 7 | Category 5 | Employee 1 | Cust 2 | 750 | 24 |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Require Output
Category | Hours |
Category 1 | 500 |
Category 2 | 400 |
Category 3 | 300 |
Category 4 | 500 |
Category 5 | 750 |
<colgroup><col><col></colgroup><tbody>
</tbody>
Thank you,