Skip to main content
Ground Control | Tier 1
April 6, 2023
Question

Filtering excel data from particular row

  • April 6, 2023
  • 2 replies
  • 565 views

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

 

    2 replies

    Zaid Chougle
    Navigator | Tier 3
    Navigator | Tier 3
    April 6, 2023

    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.

     

    Lets Automate !
    Cadet | Tier 2
    October 26, 2024

    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?