cancel
Showing results for 
Search instead for 
Did you mean: 

Filter excel data

BhavyaTaneja
Level 3
Hi,

How can we apply filter in excel?
I know we can apply filter in collections but i can't work with collections and need some solution on Excel front.

------------------------------
Bhavya Taneja
------------------------------
1 BEST ANSWER

Helpful Answers

ritansh.jatwani
Level 9
Hi @Bhavya Taneja,

You can refer the below video for applying filter on Excel:

https://www.youtube.com/watch?v=GiQgvUhbFM0&t=2s

Hope it helps :)​

------------------------------
Ritansh Jatwani Senior Consultant
Consultant
EY
Gurgaon
*If you find this post helpful mark it as best answer
------------------------------

View answer in original post

4 REPLIES 4

ritansh.jatwani
Level 9
Hi @Bhavya Taneja,

You can refer the below video for applying filter on Excel:

https://www.youtube.com/watch?v=GiQgvUhbFM0&t=2s

Hope it helps :)​

------------------------------
Ritansh Jatwani Senior Consultant
Consultant
EY
Gurgaon
*If you find this post helpful mark it as best answer
------------------------------

Thanks a lot @ritansh.jatwani.
Your video is awesome. It resolved my query. Keep uploading such cool videos. ​​

------------------------------
Bhavya Taneja
------------------------------

Thanks @Bhavya Taneja. :)​

------------------------------
Ritansh Jatwani Senior Consultant
Consultant
EY
Gurgaon
*If you find this post helpful mark it as best answer
------------------------------

Devendra_KumarP
Level 7
Hi Bhavya, 

I would suggest to use OLEDB to filter out data. Its very fast and you can apply any filter. 

Let me know if you need any other info.

------------------------------
Devendra Kumar Prajapati
Tech Lead
Infosys
Europe/London
------------------------------
Devendra Kumar Prajapati RPA Manager Infosys Chandigarh, India