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!