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!

[@newhomespace9816]

Im from Cambodia i always Suport you

[@PKAnExcelExpert]

Thanks for your valuable support

[@0222am-cje]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@mehedihasan-kf4uy]

Excellent work

[@PKAnExcelExpert]

Many thanks

[@janezklun]

Good technique, thank you for sharing

[@PKAnExcelExpert]

Most welcome

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

[@devangthakkar6847]

superb sir..... Thank you.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@nadermounir8228]

Thank u PK for this great video 📹

[@PKAnExcelExpert]

My pleasure

[@Luciano_mp]

Very good man. amazing. Thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@imransiddiqui4325]

Excellent 👌👍💯

[@PKAnExcelExpert]

Thanks 👍

[@gvinodnair]

Awesome tricks! ❤❤👍👍

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

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

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

[@sahedexpress433]

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

[@PKAnExcelExpert]

Will create soon

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

[@exceljk3361]

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

[@nayemnafi1289]

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

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

[@nitinsingh.2107]

Superr PK👌

[@PKAnExcelExpert]

Thanks

[@PlayHitsLive]

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

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

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

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

[@PKAnExcelExpert]

Please watch the below video
ua-cam.com/video/q8AZ2TGbY7M/v-deo.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🙏

[@Al-Ahdal]

1st comment

[@PKAnExcelExpert]

Thanks for watching

[@taqui-ul-hasanhaidary7715]

what to do if filter function not getting run in excel

[@PKAnExcelExpert]

It is available in office 365