79115397

Date: 2024-10-22 18:47:50
Score: 0.5
Natty:
Report link

The formula solution can be like this:

enter image description here

E2=C2
E3 and fill down=XLOOKUP(A3;$A$2:$A$6;$C$2:$C$6)-SUM(($A2:$A$2=A3)*$B2:$B$2)
Reasons:
  • Probably link only (1):
  • Low length (1):
  • Has code block (-0.5):
  • High reputation (-1):
Posted by: rotabor