Skip to main content
Question

Filtering excel data from particular row

  • April 6, 2023
  • 2 replies
  • 473 views

Forum|alt.badge.img

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
Forum|alt.badge.img+17
  • 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.

 


Forum|alt.badge.img
  • 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?