QUERY BY ANAND -2

Key Takeaways

hi friends this is Excel Guru rajinikant and today I'm going to share a solution with you guys uh and this is interview question which is asked by Anand totally 25 questions are there already one question is completed remaining 24 questions are there daily I try to upload one or two because I have to complete all 25 questions as early as possible for that reason I'm trying to solve as early as possible before starting before showing before sharing the screen I like to tell you that please like share and subscribe my channel as early as possible and click on Bell icon so that you whenever I upload a new interview MNC company questions you'll get a notification over there right now here is the screen see one thing one thing I like to tell you one thing guys before uh taking or recording video I not practicing anything directly I'm doing okay see here here they did a logic over here here the dates are in text format if you do like this it will not accept see how how they did I'm unable to uh see everyone will say like why don't use date value okay I'm using date value collect it will show you value errors suppose if I do equal to this plus 0 then also value because here in month place there is 27 23 about 12 for that reason it it is not able to understand so find the number of employees who have joined before 2015 okay here we can make it see how I do it's very simple write off whole thing control backspace comma the here in two digits okay that's enough for us don't need to take any more risk it's enough for us right two digits it will pick up two two characters from the right side that is 13 14 17 like this F9 okay without any spaces and without any special characters control Z Now what is less than 2015 right so I'll use less than I will not use direct 15 15 direct 15 is a number but here it is a text numbers observe here is a text number directly if you do 15 it will show you falses okay so you have to convert this number as a text number by double code okay then it will understand that it's a text number you are searching text number that is below 15 okay F9 wherever it find the true whereever find the less than 2015 or something it will show you the true and remaining or all Fales so convert this true and falses by using double negative mathematical operator so it will convert this into true and P F9 so simply use sum or some product so always I use some product because it can handle array in some cases some will also not help us to solve big arrays in some cases totally eight are there that is below 2015 totally eight 13 12 14 okay now coming to