solution for inphosis mis 2(12-13)

Key Takeaways

hi guys hi guys here are your friends excel guru and here i'm going to show you some amazing actually this query is asked by the company to check your skills ability and first of all i'll go to here and the person the interior wants to ask this that you have to get output like this first of all yeah again bb again triple c again 4d whenever you drag it it has to increase the zip 26 times that 26 times so how is it possible right so i will explain you this thing i'll zoom a little bit here also so that you can see before going to this solution i will show you one thing that is everyone know the ascii characters that is [Applause] okay if you enter 65 it will give you the a if you enter 66 it will give you the b right so here still here you are understood see how i'll do here first of all i'll delete here i will press 1 not 1 65 enter and what i'll do is still 26 right still 26 you'll see this okay it's not coming let me try once again see this step one okay 65 plus uh 26 of probability 91 like this so 91 let me check okay it's in rows ctrl z then i will do series columns 91 now what i'll do here i'll use the car function to show you this one see okay did you got my point what i'm going to explain you because till 1991 is not there rta to remove everything okay still now i think you are able to understand now by using this formula i will use the uh thing okay so first of all equal to cap 64 plus 1 okay i'm explaining you step by step guys so that you can able to understand here instead of one i've placed two here so b i have to instead of two i'll place three see f2 instead of of one i'll press four i have two instead of four or plus five okay till now you are able to understand this one the car function what i'll do instead of doing all one two three four five legit i will use one function that is rows the formula in f4 the the formula cell address is f4 so i do like this f dollar for colon f4 close parenthesis it is a only this bndc it will be like that one it will not change okay it will not change it will not change now we have to make like this so what i'll do here simply i use one function called repeat repeat this text how many times i'll press one to show you to understand better one one time only till here also one is there see here also one is there how many times the text should repeat one time only so what i'll do instead of doing all those things i'll copy only this formula from here ctrl c and i'll paste it over here now press enter this is the magic okay so the repeat function will do to repeat that text that the custom repetition that is it will i'll show you this thing first of all repeat ctrl shift a and i'll use the single quotation this is the text which i want to display but how many times number of times so here i said two times three times like this right are you able to understand now this one and coming to the next one wait a minute i think it's okay let it be coming to next one i should repeat only the single character repeatedly do you understand the single character should repeat as much as i can at maybe one time two times five times okay it doesn't it doesn't matter but it should repeat the custom means how many times you will give that many times it will repeat the same function which i used earlier that is 64 plus rows of n dollar fourth column and fourth okay it is in the form line enforced the given b okay um okay 64 64. [Applause] same like that but i'll do this a little bit magic over here instead of doing all those things i'll do some magic over here okay see what i'll do here instead of doing all those things simply i use this file close parenthesis i'll delete rows comma here i will use the repeat function repeat this character this many times in oneself just the company wants to the ontario wants to check your ability that what are the tricks you are going to use if it is in a complicated situation when it comes for the work how easily you can handle it right and another scenario is here here some data is there with errors like this so the company wants you should display only like this a d c f h like this okay see how i'll do here first of all what i'll do i need index of okay i'll do first thing i like to find is there any text is text just i want to check whether it is a text errors will not control only i need to check whether it's a text or not f9 it's an array actually instead accepting only the single value but i'm doing more than one so it consider an array formula so i press f9 wherever it finds this text it will show us the true and remaining or all forces f9 if the first one is true i'll press enter and i'll drag formula f2 see here what will happen it will show you the second one is the true because here is the text here is the text so second one will be the true now coming to the formula what i'll do i like to take small if is text if is text comma what you will take columns column of this whole thing f4 minus column of the whole thing f4 plus one close parenthesis and i press only one i'll show you the formula actually ah coming to here see okay again i will move a little bit wait a minute okay now okay see here okay so see what will happen first of all i'll use the east text over here okay not this one logical function f9 observe guys what i'm going to show you f9 so it will pick up the first smallest i ask her to check which one is the first to smallest so it will pick up the first to smallest from this array from this table okay so i highlight whole thing and i press f9 c1 okay still here i think you understood now what will be the index part now the index part is very very important so how you will handle you can't take whole table you have to take only the row path that is index of f2 comma see i have not logged this one close parentheses just time formula is not yet over just i want to make you to understand better for that reason i'm going step by step don't skip it if you skip it you'll miss the important things and it's an array function so you have to use ctrl shift and enters see that's it just pick corresponding value from here like c see i have two here i have shown you now i'll show you here logical test f9 and value true f9 and small i'll show you like this f9 so it pick up this there's only one number which is smallest or because it will not uh uh ignore it just it is having only one number so it will pick up that number from this small so what i'll do here what will be the row number so obviously it is two so it will pick up this here so these are the two things which i'd like to share with you it's very very important i already posted in uh file in my group in a excel online session group so if anybody wants to join please let me know and uh please like share and subscribe my channel i request everyone to share this important things just the company wants to check your ability and if you have any doubts please let me know in the comment box or in my group that is a telegram group and remaining i'll cover later because i'm getting meeting time now so i'll catch you later and thanks for your support have a nice day guys