Find Top Employee with FILTER, SORT and RANK Function in Excel

[@mehedihasan-kf4uy]

Excellent work

[@PKAnExcelExpert]

Many thanks

[@newhomespace9816]

Im from Cambodia i always Suport you

[@PKAnExcelExpert]

Thanks for your valuable support

[@devangthakkar6847]

superb sir..... Thank you.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@janezklun]

Good technique, thank you for sharing

[@PKAnExcelExpert]

Most welcome

[@nadermounir8228]

Thank u PK for this great video 📹

[@PKAnExcelExpert]

My pleasure

[@0222am-cje]

Thanks so much for good dashboards!! It helps me a lot

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@imransiddiqui4325]

Excellent 👌👍💯

[@PKAnExcelExpert]

Thanks 👍

[@Luciano_mp]

Very good man. amazing. Thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@nsanch0181]

Thank you PK for the great video. That chart looks nice with the patterns and vary by color. It was nice to use the filter, sort, offset and named ranges to make it dynamic.

[@PKAnExcelExpert]

Glad it was helpful!

[@PlayHitsLive]

जो भी इस वक़्त मेरा कमैंट् देख रहा है हम सब एक दूसरे के लिए अनजान है फिर भी मैं ईश्वर से प्रार्थना करता हु की आप के लाइफ में अगर कोई टेंशन चल रही हो तो वो दूर हो जाये | और आप हमेशा खुश रहे |☺️

[@gvinodnair]

Awesome tricks! ❤❤👍👍

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@stevereed5776]

Great video PK, you may want to think about what would happen if you only have a top 10. Selecting 11 would give an error. I'm using this trick of yours on top products sold and found this error as some customers only sell a handful of products.

[@SanviPatil2019]

superb

[@PKAnExcelExpert]

Thanks🙏

[@nitinsingh.2107]

Superr PK👌

[@PKAnExcelExpert]

Thanks

[@opekkharprohor4338]

Your video is very helpful,
Please teach me how to create Automatic Print and PDF Save Bill Cash Memo.

[@PKAnExcelExpert]

Thanks. will create soon.

[@oluwakemitowoju6080]

Good day Pyriendra Kumar. What Microsoft Excel formula can we use in place of Filter and Sort in MS Excel 2016???

[@exceljk3361]

Please help for filter function formula of multiple sheet array with multiple conditions in excel spreadsheet

[@sahedexpress433]

very helpful was this. please provide a logistics system management in excel or vba

[@PKAnExcelExpert]

Will create soon

[@nayemnafi1289]

What will be the formula if i want to show bottom 3 performer @pk

[@phabianodhiambo713]

Hey nice work. Kindly which excel version like 2019 or 2021 are you using and kindly assist the link to download it because my excel version is not good enough. Please assist

[@PKAnExcelExpert]

It is office 365

[@khadijalaalej2946]

Hello. Thank you very much for your effort.
Can you make a Dashboard for the S&OP process (Sales and Operations Process).
Thanks

[@PKAnExcelExpert]

Sure. I will try to create that

[@khadijalaalej2946]

@@PKAnExcelExpert Thank you

[@arjasarkar13]

I like you so much but I want you to start a course or a workshop on Dashboard which is your serious strength.

[@PKAnExcelExpert]

Will start soon..

[@arjasarkar13]

@@PKAnExcelExpert Sir, now a days lots of them are doing so and making huge money. So why not you as well.

[@nacerzerroug9925]

Thanks mr PK cant u help me i need a VBA code

[@vinayakdubey]

At 3:58 i am not getting filter function instead of filter i am getting FILTERXML formula. And it's not working. Like in video. Please help.

[@PKAnExcelExpert]

Filter function is available in Excel 2019 and above versions

[@vinayakdubey]

There is not developer option in my excel. How to get spin button. Please help

[@PKAnExcelExpert]

Please watch the below video
th-cam.com/video/q8AZ2TGbY7M/w-d-xo.html

[@meetuzdev]

Hi how to contact you plz? I have sent u emails but no response from you.

[@dareoluwakemi]

I am still waiting for the formulas for FILTER, SORT AND RANK in Microsoft Excel 2016

[@anbaabdellah8022]

top

[@PKAnExcelExpert]

Thanks a lot🙏

[@taqui-ul-hasanhaidary7715]

what to do if filter function not getting run in excel

[@PKAnExcelExpert]

It is available in office 365

[@Al-Ahdal]

1st comment

[@PKAnExcelExpert]

Thanks for watching