I am trying to filter excel sheet on the basis of multiple conditions as shown in zip file. But its not working properly.Please help me to resolve this issuemulfil.zip (12.3 KB)
What is expecting output ?
in your code in filter condition can you try to put the condition as “1” instead of just 1.
This should solve the issue
Let us know if not,
desired output are the columns with s.no 1 to 7 and column with s.no 35 to 50 in “time block” adn “Time Desc” columns. required outpur is shown in the given image
Thanks @pavanh003.But its not working by using “1” also.
Try as @abhilashreddyalla suggested, I tried with the same logic and got the expected result
Adding to that please add the column name in output column the 2 column names that you were extracting.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.