Need Formula data based on Multiple text/value conditions

[harinsh]

Hi Team,

Can anyone help me with below requirement....here is the data

Customer	Product Name	Amount	Contribution by	Final Status
Cust1	Product 1	17,991	Team 1
Cust2	Product 2	19,901	Team 2
Cust3	Product 3	18,948	Team 3
Cust3	Product 3	10,730	Team 1
Cust5	Product 5	16,754	Team 3
Cust6	Product 6	12,324	Team 1
Cust7	Product 7	11,813	Team 3
Cust8	Product 8	11,634	Team 1
Cust9	Product 9	17,742	Team 2
Cust9	Product 9	13,426	Team 3
Cust11	Product 11	14,678	Team 1
Cust12	Product 12	17,431	Team 3
Cust14	Product 14	14,932	Team 3
Cust14	Product 14	17,393	Team 3
Cust15	Product 14	18,962	Team 3
Cust16	Product 16	14,647	Team 1
Cust17	Product 17	16,890	Team 1
Cust18	Product 18	10,779	Team 1
Cust20	Product 19	11,129	Team 1
Cust20	Product 19	10,422	Team 2

<tbody>
</tbody>

Looking for formula to get the final status as which team owned the product/customer. Assume there are only three teams leading the projects and each team associates with customer. If customer and product same and amount greater in value then I should get the which team owned the project.....for example if customer 20 and product 19 contributed by two teams however I should get T1 Own because greater amount pertains to Team 1.

Here should be the output....

Customer	Product Name	Amount	Contribution by	Final Status
Cust1	Product 1	17,991	Team 1	T1 Own
Cust2	Product 2	19,901	Team 2	T2 Own
Cust3	Product 3	18,948	Team 3	T3 Own
Cust3	Product 3	10,730	Team 1	T3 Own
Cust5	Product 5	16,754	Team 3	T3 Own
Cust6	Product 6	12,324	Team 1	T1 Own
Cust7	Product 7	11,813	Team 3	T3 Own
Cust8	Product 8	11,634	Team 1	T1 Own
Cust9	Product 9	17,742	Team 2	T2 Own
Cust9	Product 9	13,426	Team 3	T2 Own
Cust11	Product 11	14,678	Team 1	T1 Own
Cust12	Product 12	17,431	Team 3	T3 Own
Cust14	Product 14	14,932	Team 3	T3 Own
Cust14	Product 14	17,393	Team 3	T3 Own
Cust15	Product 14	18,962	Team 3	T3 Own
Cust16	Product 16	14,647	Team 1	T1 Own
Cust17	Product 17	16,890	Team 1	T1 Own
Cust18	Product 18	10,779	Team 1	T1 Own
Cust20	Product 19	11,129	Team 1	T1 Own
Cust20	Product 19	10,422	Team 2	T1 Own

<tbody>
</tbody>

Let me know if any further clarification. Your help greatly appreciate ...Thank you

 

[harinsh]

Thank you for the explanation...