79310025

Date: 2024-12-26 17:14:44
Score: 0.5
Natty:
Report link

I have found this to be the most compact answer:

=ArrayFormula(SUM(--(COUNTIF(A1:A7;A1:A7)=2))/2) #for doubles
=ArrayFormula(SUM(--(COUNTIF(A1:A7;A1:A7)=3))/3) #for triples

Dropping the "ArrayFormula" component to use in excel.

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Pedro Schuller