Skip to main content

Hi guys, i have data in excel which starts from 4th row, i need to filter P column with value [West]. how can i do using A360.

 

excel data

 

Hi @ali 679 ,

 

You can use Filter table for this : 

Also as you excel starts from Row 4, you can use the loop of For each row in excel and send the starting as row 4 and also get number of rows to get the total number of rows.

Let me know whether the solution works or not.

 


How can i remove a filter or all filters from a sheet? in the filter option it ask if I want to lear all existing filters but below it asks to filter again. I want to open the excel next time without any filters?


Reply