Very Helpful - clear and well-paced👍 instruction - thanks
@sayeethujagafar937515 күн бұрын
Getting error #VALUE
@santoshbaskey29 күн бұрын
So amazing thanks so much.
@Ultimatelegend-x5pАй бұрын
5:26 you are giving incorrect answer in the answers i checked it is incorrect
@user-kq6ud3og7uАй бұрын
Amazing Video 👍👍
@AnuranjanHari2 ай бұрын
very useful for me....thanks sir.....
@KnowHow712Ай бұрын
Welcome
@stewartwilkinsonsnr2 ай бұрын
I was so happy to find your channel, I’ve been trying to make a Search Box in order to search over 42,000 Locations in the UK. Every channel I found the instructions were at top speed, which was no good to me. You young sir were just right so Thank You. I now have a lovely Search Box that works. Kind Regards from Stewart UK 🇬🇧👏
@KnowHow712Ай бұрын
Glad I could help!
@MadonnaRaspe3 ай бұрын
It really helped me complete my assignment thank you❤
@KnowHow7123 ай бұрын
Happy it was helpful for you
@vlogmuneeb3 ай бұрын
Nice work.
@KnowHow7123 ай бұрын
Thank you.
@turcsanyirobert12894 ай бұрын
why the formula doesnt work for me? it doesnt see it as a formula..:(
@KnowHow7123 ай бұрын
Try to remove any error while typing it will definately work.
@Rezka_tv_4 ай бұрын
Thank you bro 👍
@KnowHow7124 ай бұрын
Welcome.
@anhhoangminh94744 ай бұрын
Good.
@KnowHow7124 ай бұрын
Thanks
@ck61774 ай бұрын
Superb video sir .Thank you very much.Apart from inprocess and completed can we get stages where it is running now like phase-1 or phase -2 like that
@KnowHow7124 ай бұрын
Thanks, will upload soon.
@ubaidillahmuhammad204 ай бұрын
nice. give the excel files
@KnowHow7124 ай бұрын
Thanks a lot
@CVFREVOLFAJARPAPUA4 ай бұрын
Thank you so much
@KnowHow7124 ай бұрын
You're most welcome
@CVFREVOLFAJARPAPUA4 ай бұрын
Super tutorial so much helpful
@KnowHow7124 ай бұрын
Glad it was helpful!
@CVFREVOLFAJARPAPUA4 ай бұрын
Thank you so much for the meaningful tutorial
@KnowHow7124 ай бұрын
You are so welcome!
@reesereyes60785 ай бұрын
i hope this video blows up aaaa thank youu for the tutorial
@KnowHow7125 ай бұрын
You are welcome.
@mdfrahim9165 ай бұрын
if some value is less than 8, this formula is not working. how do you calculate then?
@KnowHow7125 ай бұрын
While calculating overtime we have used the formula =E4-Time(8,0,0) , considering regular 8 hour daily working time. We must amend this formula if the regular working hours are less than 8. For example, if the working hour is 6 than we will write this formula as =E4-Time(6,0,0) and everything will be working fine.
@user-ft4wd4gh4u5 ай бұрын
Nice
@KnowHow7125 ай бұрын
Thanks
@vlogmuneeb5 ай бұрын
👍💯
@KnowHow7125 ай бұрын
Thanks you so much.
@Masishamo5 ай бұрын
Aoa In index should we select whole range including header row and columns or mere the values from which we are looking for desired value? It often confuse me. Plz guide
@KnowHow7125 ай бұрын
Walikum salam, If we do not select headers of columns than we will use following formula to get the sales 2019: =INDEX(B4:G18,MATCH(J3,C4:C18,0),3) Otherwise we can also select headers as I have explained that method in the video. So, its how you use this formula. I am sharing sheet link in the description with both possibilities for your practice. Thanks for your interest. Keep connected.
@user-gf7fx1qy6c6 ай бұрын
At the last video where does the 24 came from
@KnowHow7126 ай бұрын
Because we are multiplying overtime, which is in time format and must be converted to decimal before we multiply it with the overtime pay rate to get total overtime pay. In our example when we multiply 4:30 with 24 we get 4.5 that is good to multiply with $50 to get the $225. I hope you understand the reason. Thanks for watching keep connected.
@markdavies42556 ай бұрын
Enjoy the Video
@KnowHow7126 ай бұрын
Thanks for the appreciation.
@karunakarboini12026 ай бұрын
thank you Sir
@KnowHow7126 ай бұрын
Most welcome.
@KnowHow7126 ай бұрын
Most welcome.
@vlogmuneeb6 ай бұрын
Very Nice. Learned a lot from your videos. Thank you.
@KnowHow7126 ай бұрын
You are welcome. Stay connected.
@bobcaruthers44276 ай бұрын
Does not work for me. When I use this formula it just highlights my entire table. Searching for any term does absolutely nothing.
@KnowHow7126 ай бұрын
It usually happen when we do not use the absolute value in the formula that is by by pressing F4. Still if you found it difficult to apply I have another special video on developing search box with another method. May be it work best for you. The link of the video is: kzbin.info/www/bejne/l4CtmKSgqZaMj8ksi=h4Y-x9CKeSynTrHA
@bobcaruthers44276 ай бұрын
Thanks, got it sorted, keep up the great work.
@legrandfromage64506 ай бұрын
What are the little left-right arrows in the bottom left hand corner of the interface, at the far left end of the status bar? What do they do?
@KnowHow7126 ай бұрын
These are the Sheet Tab Scroll Buttons. The Sheet Tab Scroll Buttons are another means of navigating between sheets of the workbook other than selecting a tab. Thanks for asking, Keep connected to KnowHow.
@Michael_Alaska6 ай бұрын
Seems dated for those with Office 365 who can simply insert a checkbox without the developer tab. Useful for those without though. Thanks.
@KnowHow7126 ай бұрын
Most welcome. Exactly, for office 365 user they can directly add check boxes however developer tab option is for everyone. The most interesting part is how these check boxes are linked with conditional formatting. I hope you have enjoyed that.
@ragulmarley49006 ай бұрын
Nice 🙂 do more condition formatting videos
@KnowHow7126 ай бұрын
Thanks. Yes, I will be uploading more on conditional formatting surely.
@RafaelFernando-rs4dy6 ай бұрын
Thank you!
@KnowHow7126 ай бұрын
Most Welcome.
@gigabitcom126 ай бұрын
Thank so much. This is very helpful
@KnowHow7126 ай бұрын
You are welcome. Stay connected.
@phandongexcel6 ай бұрын
I like this video and comment! I’m from Vietnam and you? www.youtube.com/@phandongexcel❤❤❤
@KnowHow7126 ай бұрын
Thank you so much. I am from Pakistan.
@meharadnan18776 ай бұрын
Sorry to say,,,,what is learning in this tutorial....its simply showing of some of your personal skills in excel......not useful for others.....
@KnowHow7126 ай бұрын
Thanks for your feedback. My personal skills may not be useful for you but it may be useful for other who are interested in developing excel skills. So, I think its the matter of interest....
@user-ft4wd4gh4u6 ай бұрын
Very nicely described. Thanks a lot.
@KnowHow7126 ай бұрын
Thank you so much.
@subramanyaba92977 ай бұрын
Please upload formulas v lookup more type s
@KnowHow7127 ай бұрын
Sure, I'll cover different types of VLOOKUP formulas in an upcoming video. Stay tuned!