79229460

Date: 2024-11-27 08:36:09
Score: 0.5
Natty:
Report link

The formula is

=MAX(SCAN(1,DROP(UNIQUE(A:A),1),LAMBDA(aa,b,COUNTIF(A:A,b)+aa-1)))-1

Do not place it in column A, since it is the dynamic range of the data. (circular reference)

enter image description here

Reasons:
  • Probably link only (1):
  • Low length (1):
  • Has code block (-0.5):
  • High reputation (-1):
Posted by: Black cat