I excel sheet there is some set of datas. In that i want filter 7 set of datas and paste in another sheet.
Can you share the same excel file and tell more about the filter mechanism
Book1.xlsx (11.4 KB)
Hello @Aarthy1 , What data Need to filter From Excel? Could you explain more about your requirement. Does it filter data between the ranges? like 50 to 100 ?
filter datatable you can use there you can mention column name also operators you can select like lessthan , greater then,equals, between
I tried filter table but it not working
can you tell me in what basis you want to filter?