topic Filter excel data in Product Forum

Filter excel data

BhavyaTaneja — Sat, 07 Aug 2021 18:25:00 GMT

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

RE: Filter excel data

ritansh.jatwani — Sat, 07 Aug 2021 19:05:00 GMT

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

RE: Filter excel data

BhavyaTaneja — Sun, 08 Aug 2021 19:09:00 GMT

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

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

RE: Filter excel data

ritansh.jatwani — Sun, 08 Aug 2021 20:55:00 GMT

Thanks @Bhavya Taneja. :)

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

RE: Filter excel data

Devendra_KumarP — Tue, 10 Aug 2021 15:29:00 GMT

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