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.
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.
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
जो भी इस वक़्त मेरा कमैंट् देख रहा है हम सब एक दूसरे के लिए अनजान है फिर भी मैं ईश्वर से प्रार्थना करता हु की आप के लाइफ में अगर कोई टेंशन चल रही हो तो वो दूर हो जाये | और आप हमेशा खुश रहे |☺️
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.
Glad it was helpful!
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.
Thanks so much for good dashboards!! It helps me a lot
Thanks for your valuable feedback🙏
Good technique, thank you for sharing
Most welcome
Excellent work
Many thanks
Very good man. amazing. Thank you!
Thanks for your valuable feedback🙏
Im from Cambodia i always Suport you
Thanks for your valuable support
Thank u PK for this great video 📹
My pleasure
superb sir..... Thank you.
Thanks for your valuable feedback🙏
Excellent 👌👍💯
Thanks 👍
Awesome tricks! ❤❤👍👍
Thanks for your valuable feedback🙏
Your video is very helpful,
Please teach me how to create Automatic Print and PDF Save Bill Cash Memo.
Thanks. will create soon.
I like you so much but I want you to start a course or a workshop on Dashboard which is your serious strength.
Will start soon..
@@PKAnExcelExpert Sir, now a days lots of them are doing so and making huge money. So why not you as well.
very helpful was this. please provide a logistics system management in excel or vba
Will create soon
Good day Pyriendra Kumar. What Microsoft Excel formula can we use in place of Filter and Sort in MS Excel 2016???
superb
Thanks🙏
Hello. Thank you very much for your effort.
Can you make a Dashboard for the S&OP process (Sales and Operations Process).
Thanks
Sure. I will try to create that
@@PKAnExcelExpert Thank you
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
It is office 365
Please help for filter function formula of multiple sheet array with multiple conditions in excel spreadsheet
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.
Filter function is available in Excel 2019 and above versions
What will be the formula if i want to show bottom 3 performer @pk
Superr PK👌
Thanks
I am still waiting for the formulas for FILTER, SORT AND RANK in Microsoft Excel 2016
Thanks mr PK cant u help me i need a VBA code
There is not developer option in my excel. How to get spin button. Please help
Please watch the below video
ruclips.net/video/q8AZ2TGbY7M/видео.html
Hi how to contact you plz? I have sent u emails but no response from you.
top
Thanks a lot🙏
जो भी इस वक़्त मेरा कमैंट् देख रहा है हम सब एक दूसरे के लिए अनजान है फिर भी मैं ईश्वर से प्रार्थना करता हु की आप के लाइफ में अगर कोई टेंशन चल रही हो तो वो दूर हो जाये | और आप हमेशा खुश रहे |☺️
what to do if filter function not getting run in excel
It is available in office 365
1st comment
Thanks for watching