79598077

Date: 2025-04-29 10:00:46
Score: 2.5
Natty:
Report link

Use UNIQUE() and AVERAGEIF():

=UNIQUE(A2:A11) in cell E2;

=AVERAGEIF(A2:A11;E2#;B2:B11)

Solution

Reasons:
  • Probably link only (1):
  • Low length (1.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Excellor