79192609

Date: 2024-11-15 13:40:35
Score: 0.5
Natty:
Report link

If already upgraded to 365

=LET(res,CONCAT(TOCOL(IF(A1:A11<>1,ADDRESS(ROW(A1:A11),COLUMN(A1:A11),4,1),1/0),2)&","),
LEFT(res,LEN(res)-1))

enter image description here

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