Thank you.
All i did was export excel data in R.
Maybe for one ID easier to explan what i want.
In the first step just for ID1 i want to calculate:
for each cell A(3,2,4,5), calculate sum of number larger then select number. So first selected number is 3, larger numbers than 3 is 4 and 5 sum is 9. Then calculate especially for number 2, 4, 5.
I hope I explained to you
i 