In column A I have the name of employees and In column B I have the target value that they achieved. Now I want that the employee who achieved the highest target, other employees contributes their value to him. Like if any employee who achieved 51% target of Highest target employee value then he contributes Rs 100 and if other employees who achieved 26 to less than 51% of highest target value employee then they contributes Rs 150 and for less than or equal to 25 % contributes Rs 200.

My list is like below.

Emp Name Tgt Acd Highest Emp Final Result

A 20 70 is highest 20 is 28 % of 70 ..now A pay to C 150 Rs

B 10 10 is 14% of 70..now B pay to C 200 Rs

C 70

D 45 45 is 64% of 70..now D pay to C Rs 100

E 50