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

[@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!

[@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.

[@0222am-cje]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@janezklun]

Good technique, thank you for sharing

[@PKAnExcelExpert]

Most welcome

[@mehedihasan-kf4uy]

Excellent work

[@PKAnExcelExpert]

Many thanks

[@Luciano_mp]

Very good man. amazing. Thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@newhomespace9816]

Im from Cambodia i always Suport you

[@PKAnExcelExpert]

Thanks for your valuable support

[@nadermounir8228]

Thank u PK for this great video 📹

[@PKAnExcelExpert]

My pleasure

[@devangthakkar6847]

superb sir..... Thank you.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@imransiddiqui4325]

Excellent 👌👍💯

[@PKAnExcelExpert]

Thanks 👍

[@gvinodnair]

Awesome tricks! ❤❤👍👍

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@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.

[@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.

[@sahedexpress433]

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

[@PKAnExcelExpert]

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

[@SanviPatil2019]

superb

[@PKAnExcelExpert]

Thanks🙏

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

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

[@exceljk3361]

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

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

[@nayemnafi1289]

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

[@nitinsingh.2107]

Superr PK👌

[@PKAnExcelExpert]

Thanks

[@dareoluwakemi]

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

[@nacerzerroug9925]

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

[@vinayakdubey]

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

[@PKAnExcelExpert]

Please watch the below video
ruclips.net/video/q8AZ2TGbY7M/видео.html

[@meetuzdev]

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

[@anbaabdellah8022]

top

[@PKAnExcelExpert]

Thanks a lot🙏

[@PlayHitsLive]

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

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