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

2 жыл бұрын

Glad it was helpful!

Very good man. amazing. Thank you!

@PKAnExcelExpert

2 жыл бұрын

Thanks for your valuable feedback🙏

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

@PKAnExcelExpert

2 жыл бұрын

Thanks for your valuable feedback🙏

Good technique, thank you for sharing

@PKAnExcelExpert

2 жыл бұрын

Most welcome

Thank u PK for this great video 📹

@PKAnExcelExpert

2 жыл бұрын

My pleasure

Awesome tricks! ❤❤👍👍

@PKAnExcelExpert

2 жыл бұрын

Thanks for your valuable feedback🙏

Im from Cambodia i always Suport you

@PKAnExcelExpert

2 жыл бұрын

Thanks for your valuable support

superb sir..... Thank you.

@PKAnExcelExpert

2 жыл бұрын

Thanks for your valuable feedback🙏

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.

Excellent work

@PKAnExcelExpert

11 ай бұрын

Many thanks

Excellent 👌👍💯

@PKAnExcelExpert

5 ай бұрын

Thanks 👍

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

superb

@PKAnExcelExpert

2 жыл бұрын

Thanks🙏

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

@PKAnExcelExpert

2 жыл бұрын

Will create soon

Superr PK👌

@PKAnExcelExpert

2 жыл бұрын

Thanks

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

@PKAnExcelExpert

2 жыл бұрын

Sure. I will try to create that

@khadijalaalej2946

2 жыл бұрын

@@PKAnExcelExpert Thank you

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

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

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

2 жыл бұрын

It is office 365

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

@PKAnExcelExpert

2 жыл бұрын

Thanks. will create soon.

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

top

@PKAnExcelExpert

2 жыл бұрын

Thanks a lot🙏

1st comment

@PKAnExcelExpert

2 жыл бұрын

Thanks for watching

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

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

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

@PKAnExcelExpert

2 жыл бұрын

Will start soon..

@arjasarkar13

2 жыл бұрын

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

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

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

@PKAnExcelExpert

Жыл бұрын

Please watch the below video kzread.info/dash/bejne/o2x1vJSNd8W_Z7A.html

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

what to do if filter function not getting run in excel

@PKAnExcelExpert

2 жыл бұрын

It is available in office 365