How to measure row length in excel?

Hi, I am trying to measure the row length in excel, the condition is row(“NA”) equals to str_item1 or str_item2 or str_item3. I wrote the function according to my own understanding, but there was a error. Please help me solve the problem. Thank you!image

1 Like

@guowq

Buddy Try to mention as

row(“NA”).ToString.equals(str_item1) or row(“NA”).ToString.equals(str_item2)

Cheers

Your or condition is wrong. It should be

row("NA").ToString = str_item1 OR row("NA").ToString = str_Item2

1 Like

@guowq

is that working buddy…

Cheers…

Thank you for helping !

1 Like

Cheers buddy @guowq

Keep going…

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.