The best tutorial on this topic that I have found. Extremely insightful and useful, especially if you work with these kind of things 👌🙏👌

@PKAnExcelExpert

Жыл бұрын

Thanks for your valuable feedback🙏

I'm grateful for having you as my mentor. your channel has really helped me grow my channel. Thank you very much PK. You are indeed an Excel Expert

@loky787

Жыл бұрын

Wow! It’s for children! ))) make it !

This is one of the best tutorials I have watched so far. Thanks for sharing Sir.

@PKAnExcelExpert

Жыл бұрын

Glad it was helpful!

Thank you for the great video on drop drowns with new 365 features. I learn so much from you PK.

@PKAnExcelExpert

Жыл бұрын

Most welcome

It's very useful and easy to understand. Thank you so much.

@PKAnExcelExpert

Жыл бұрын

Glad to hear that!

A valuable learning today. Thank you

@PKAnExcelExpert

Жыл бұрын

Most welcome🙏

Very nice and helpful video, thank you very much

@PKAnExcelExpert

10 ай бұрын

You are welcome

You are genius.. I learned lot from you..Thanks a lot sir.

@PKAnExcelExpert

Жыл бұрын

Most welcome🙏

This is great stuff! Thank you!

@PKAnExcelExpert

Жыл бұрын

Most welcome

Thanks for sharing your knowledge.

@PKAnExcelExpert

Жыл бұрын

My pleasure!

Thank you PK for this great video 📹 👏

@PKAnExcelExpert

Жыл бұрын

My pleasure

Very helpful video. Thank you.

@PKAnExcelExpert

Жыл бұрын

Most welcome

Thanks for this amazing video.

@PKAnExcelExpert

Жыл бұрын

Most welcome🙏

Thank you so much, Sir.

@PKAnExcelExpert

Жыл бұрын

Most welcome🙏

It's too good. Thanks a lot.

@PKAnExcelExpert

Жыл бұрын

Most welcome 😊

Thank you so much Very nice tutor video

@PKAnExcelExpert

Жыл бұрын

You are most welcome

Great post

@PKAnExcelExpert

Жыл бұрын

Glad you enjoyed it

Great video...would it be possible to make the database a table and /or name range each column then you would not need to highlight all the cells in the columns? Thanks

Great video Thank you. Coud you make a video about stock control in same codes.I mean Have products have some input materials buying from firms and some selling records to another firms .We need check stocks (total inputs in a line and total sells in a line and stock quantity in our stok for same material Thank you

Hi there. The raw data should be put in an Excel table (CTRL+T). Then you would have a much easier time creating references in your formulas and also you wouldn't have to worry about updating the entries when new rows are added to the table. That would be automatic. And you would be able to also type below the table(s). As it stands right now you can't do this because you've had to pass almost the whole column to your formulas. Please, when you can use Excel tables. They are much safer than just plain ranges. On top of that, I'd suggest naming ranges as well. This will then enable you to get rid of the ugly long references.

@purpleparadise2001

Жыл бұрын

Instead of ctrl+T, we can use offset func and countA func so that we can make that as dynamic array result and we can name that array and can be used in dropdown.

@SumeragiMinami

Жыл бұрын

@@purpleparadise2001 Can you give me a formula example regarding the use of offset and counta to make a dynamic array?

very great video. can this be done in other excel versions?

Nice video sir…

@PKAnExcelExpert

Жыл бұрын

Thanks a lot🙏

Good evening Pryiendra Kumar Which formulas can we use in place of UNIQUE, FILTER AND SORT in earlier versions of Microsoft Excel (2016 to be precise)

Thanks. Can I have the formulas you used the filter and unique for all the steps. I find it difficult to see the formula used.

Hi, may I know if the searchable feature is limited to Excel on Windows? I can't seem to get that to work on my Mac. Thank you!

Can that be applied to make multiple dependent drop down list for example 5 or 6 levels?’

Very unique...need help on 1report can you help....

Sir PK I'm thinking of creating a whole school report, attendance register using Excel with functionality of password for individual user teacher... Please can this be a possibility in Excel 2013?

Hi pk, Pk utility tools, there have been you mentioned Searchable Dorp down list, it's not working, kindly check

the dash board has a bar chart and data table please help is to create it especially the data table thanks

Hi Is it possible to apply, graphical view for the dynamic data here? can you check and guide on it? so basically the graph applied will also be dynamic

boss please provide a business management system in vba Excel

@PKAnExcelExpert

Жыл бұрын

Great suggestion! I will try to create a video on this topic.

Put data in a table then try "=unique(Table1[Location])"

Good one. But I'm not getting searchable function Pl help

What is the code for the task from 01.09 to 01.14? What order should be given? ..."tar"?? I don't understand what needs to be done to make the selection appear after the letter.

will this work on normal excel ?

List is not showing names by pressing the any letter and not fetching any values i followed the same whats the error plz

hii, could make formula for multiple Dependent Drop-Down Lists in Excel (on Every Row) ?

@PKAnExcelExpert

11 ай бұрын

will try

sir, will it only work on office 365?

❤💯🤟

@PKAnExcelExpert

Жыл бұрын

Thanks

Sir it is very nice but creating formula is slightly complicated. Pl send readymade template

@PKAnExcelExpert

Жыл бұрын

Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com

hi ..why Searchable list not work with me i use 365 ???

Can make chess tournament competition software

hello sir, i have no filter here... when i type A or B or name theres no show the letter or the name i looking for, i'm using Ms. 365 Ent. Good Tutorial by the way. thanks.

@irfanabbassi9202

Жыл бұрын

function is in insider edition only..Which means its in testing...

@justmusic2010

Жыл бұрын

@@irfanabbassi9202 ah i see, thanks fyi...

It's not showing "Unique" function key in my excel-2019

@PKAnExcelExpert

Жыл бұрын

It is available in office 365

Dear PK Pl help

hello PK , there is a dashboard board given me difficulty the site is CDC.gov on reduced access to hearing care . can you help us create the dashboard and notify us when you are done . thanks