How to count filled cells under a specific column which is dynamic?

There are a total of 2 excel files involved.
1st: With name, department, start date and end date
In which I used ‘read range’ and ‘get row item’ to get the above information into variables

So what I have to do is to open the other excel (pic) and check under the specific column, how many cells are filled. If it is more than 2, then I will have to create a new row and write “no” in the 1st excel file. But the tricky part is I only want to check those under the department “cleaning” - this will be dynamic. how can I do that?

Thanks in advance!

if row(0).ToString.Equals("")
in else part
nonEmptyRows = row(0).ToString
and print nonEmptyRows

please dont create more than one of the same question…