79147690

Date: 2024-11-01 10:44:23
Score: 2
Natty:
Report link

Vohratom C:C is undefined, nest with bycol and its range define in LAMBDA,it will work.

{"DIVIDEND"; BYROW(A2:A; LAMBDA(r;BYCOL(C2:C;LAMBDA (c,IF(c="Dividend";IFNA(SUBSTITUTE(IMPORTXML(CONCATENATE("https://finviz.com/quote.ashx?t=";r);'XML IMPORT'!C$3)));".";",")/4);"-")))}

Check 2 close parenthesis ,if I was misplaced

Reasons:
  • No code block (0.5):
  • Contains question mark (0.5):
  • Low reputation (1):
Posted by: Suresh Patel