Filter excel data

[BhavyaTaneja]

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
------------------------------

[ritansh.jatwani · Accepted solution]

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
------------------------------

[BhavyaTaneja]

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

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

[ritansh.jatwani]

Thanks @Bhavya Taneja. :)​

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

[Devendra_KumarP]

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
------------------------------