Тёмный

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

PK: An Excel Expert
Подписаться 272 тыс.
Просмотров 21 тыс.
50% 1

#ExcelFunction #Excel365
Hello Friends,
In this video, you will learn how to find top selected employee with the help of FILTER and RANK Function. You will also learn the SORT and OFFSET Function. We have also explained the form control Spin button and dynamic chart with Named Range.
Download the practice file from the below link:
www.pk-anexcelexpert.com/find...
See how to send bulk email part 1 of this video:
• Automation: Send bulk ...
See our more Power BI videos:
• Power BI Tutorial
Learn and download our interactive Excel dashboards free of cost-
• Excel Dashboards
Download the Free Project Management Dashboard
www.pk-anexcelexpert.com/exce...
Download the Calendar Control in VBA from below link
www.pk-anexcelexpert.com/full...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
LinkedIn:
/ pk-anexcelexpert
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...

Опубликовано:

 

6 июн 2022

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 54   
@nsanch0181
@nsanch0181 2 года назад
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
@PKAnExcelExpert 2 года назад
Glad it was helpful!
@Luciano_mp
@Luciano_mp 2 года назад
Very good man. amazing. Thank you!
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thanks for your valuable feedback🙏
@user-ee8qn7qk4r
@user-ee8qn7qk4r 2 года назад
Thanks so much for good dashboards!! It helps me a lot
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thanks for your valuable feedback🙏
@janezklun
@janezklun 2 года назад
Good technique, thank you for sharing
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Most welcome
@nadermounir8228
@nadermounir8228 2 года назад
Thank u PK for this great video 📹
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
My pleasure
@gvinodnair
@gvinodnair 2 года назад
Awesome tricks! ❤❤👍👍
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thanks for your valuable feedback🙏
@newhomespace9816
@newhomespace9816 2 года назад
Im from Cambodia i always Suport you
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thanks for your valuable support
@devangthakkar6847
@devangthakkar6847 2 года назад
superb sir..... Thank you.
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thanks for your valuable feedback🙏
@stevereed5776
@stevereed5776 2 года назад
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.
@mehedihasan-kf4uy
@mehedihasan-kf4uy Год назад
Excellent work
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Many thanks
@imransiddiqui4325
@imransiddiqui4325 6 месяцев назад
Excellent 👌👍💯
@PKAnExcelExpert
@PKAnExcelExpert 6 месяцев назад
Thanks 👍
@SanviPatil2019
@SanviPatil2019 2 года назад
superb
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thanks🙏
@nitinsingh.2107
@nitinsingh.2107 2 года назад
Superr PK👌
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thanks
@oluwakemitowoju6080
@oluwakemitowoju6080 Год назад
Good day Pyriendra Kumar. What Microsoft Excel formula can we use in place of Filter and Sort in MS Excel 2016???
@sahedexpress433
@sahedexpress433 2 года назад
very helpful was this. please provide a logistics system management in excel or vba
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Will create soon
@khadijalaalej2946
@khadijalaalej2946 2 года назад
Hello. Thank you very much for your effort. Can you make a Dashboard for the S&OP process (Sales and Operations Process). Thanks
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Sure. I will try to create that
@khadijalaalej2946
@khadijalaalej2946 2 года назад
@@PKAnExcelExpert Thank you
@opekkharprohor4338
@opekkharprohor4338 2 года назад
Your video is very helpful, Please teach me how to create Automatic Print and PDF Save Bill Cash Memo.
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thanks. will create soon.
@anbaabdellah8022
@anbaabdellah8022 2 года назад
top
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thanks a lot🙏
@exceljk3361
@exceljk3361 2 года назад
Please help for filter function formula of multiple sheet array with multiple conditions in excel spreadsheet
@Al-Ahdal
@Al-Ahdal 2 года назад
1st comment
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thanks for watching
@phabianodhiambo713
@phabianodhiambo713 2 года назад
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
@PKAnExcelExpert 2 года назад
It is office 365
@nayemnafi1289
@nayemnafi1289 2 года назад
What will be the formula if i want to show bottom 3 performer @pk
@HADI-UPDATE
@HADI-UPDATE 2 года назад
जो भी इस वक़्त मेरा कमैंट् देख रहा है हम सब एक दूसरे के लिए अनजान है फिर भी मैं ईश्वर से प्रार्थना करता हु की आप के लाइफ में अगर कोई टेंशन चल रही हो तो वो दूर हो जाये | और आप हमेशा खुश रहे |☺️
@arjasarkar13
@arjasarkar13 2 года назад
I like you so much but I want you to start a course or a workshop on Dashboard which is your serious strength.
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Will start soon..
@arjasarkar13
@arjasarkar13 2 года назад
@@PKAnExcelExpert Sir, now a days lots of them are doing so and making huge money. So why not you as well.
@nacerzerroug9925
@nacerzerroug9925 2 года назад
Thanks mr PK cant u help me i need a VBA code
@dareoluwakemi
@dareoluwakemi Год назад
I am still waiting for the formulas for FILTER, SORT AND RANK in Microsoft Excel 2016
@vinayakdubey
@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
@PKAnExcelExpert Год назад
Filter function is available in Excel 2019 and above versions
@meetuzdev
@meetuzdev 2 года назад
Hi how to contact you plz? I have sent u emails but no response from you.
@vinayakdubey
@vinayakdubey Год назад
There is not developer option in my excel. How to get spin button. Please help
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Please watch the below video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-q8AZ2TGbY7M.html
@taqui-ul-hasanhaidary7715
@taqui-ul-hasanhaidary7715 2 года назад
what to do if filter function not getting run in excel
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
It is available in office 365
Далее
Sales Analysis Heat Map by Time and Day
11:11
Просмотров 17 тыс.
FILTER in Excel - Limit, Sort, & Rank
11:04
Просмотров 17 тыс.
Excel's NEW Checkboxes Are Incredibly Cool! Here's why
14:24
Make a Search Bar in Excel to Find Anything!
10:35
Просмотров 340 тыс.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Show Top Ten Results - Excel PivotTable Tricks
8:08
Просмотров 102 тыс.