MIS QUERY

Key Takeaways

hi guys this is Rik once again and here previously I asked one quy to find out the maximum length of characters that is this one okay so how you will do that one and another thing that I got in previous that is how to get this one the character three length characters minimum and count these two things okay then these two things I have to find okay then we will make it okay done now what I'll do here first of all I will show you this one right so for that first of all what you will do you have to find uh right here I will do is equal to length of this whole thing right if I press F9 it will show you like this the it will count all the characters the length of characters now we want a maximum length of characters that is some n o Qs okay so for that reason you have to find you have to use max of same length after to this one so here what will happen means it will show you the uh whereever it find this first of all I'll press enter F2 see F9 here and again f F9 here so it will count 1 2 3 4 5 6 7 this one okay maximum length of character so whereever it find this one it will show you the true and remaining are all falses F9 see only one true is there that is this 1 2 3 4 1 2 3 4 5 6 1 2 3 4 5 6 so this is the maximum character it will show now what I said you have to find with we look up so here here what I'll use I'll use a choose function choose I'm taking two actually to expect only the one or like that but it's an array so I'm using two right this is the first it will pick up this one and the second one is this one only okay here is the choose F9 see false critic both we take a both that is because I used here one and two so we are telling to the formula that pick up the two things okay one is the condition and another one is the output these two things you have to pick up and show me the result that is by pressing F9 you can find it out the true see right now what I said you have to find by V lookup only Max and Min okay so what I'll do here I'll use V lookup and lookup value will be the true okay look value will be the two where it has to pick up sorry for Interruption sorry for Interruption okay I think you able to see this one okay so look up value will be the true and look up array will be this F9 so what you need you need second one so comma 2 comma 0 and if if I press enter it will give you the either uh this one only first one or actually for this it will give you the error I think so oh yes it will the first one first occurrence but it's an array function you have to use control shift and enter if I change anything more than that many characters like see got it what I mean to explain you and and if you have any doubts you can ask me in the telegram group okay in the description I'll mention the telegram group link if anybody wants to join they can welcome okay and another thing is this one okay you have to find I'll Zoom a little bit this is the previous one okay first one is this is the previous one which I'm going to show you right now you have to to find the minimum of third length characters okay third length characters okay we'll make it is equal to same you have to use here you have to use IF function if length of this whole thing comma if it is true pick up the same thing control shift down arrow okay okay so it will show you the sorry if length of this equal to this if it is true I forgot this condition over here if it is true so pick up only three length characters F9 so whever it find the three length character it will show you like this and simply use Min function it's an array function so you have to use Min of control shift and enters if I change to four see for same what you say for same for maximum also for same you instead of Min you have to use max over here that's it Max off now I previously explained you how to do with the count of four length characters it's the same simple way count if the whole table this one comma repeat let's try with this it will work it out or not comma because it will not work I think so let's try it will not work see it will not work so here you have to use again you have to use the same length of because a number length of equal to this close parenthesis and close parenthesis F9 so convert Tru into numbers true as one and false as zero so for that reason you have to use double negative over here and press F9 see simply use some product for this and it will add automatically some product enter some product can handle array so four characters see here this one and this one I will highlight and these three things I will highlight with this red and c and Border also I change so that you easily you can identify like hone so see if I change to three it will change and it will also change because and individually I it and here has an array so three see eight eight three characters okay guys and someone ask this one 321 comma 320 something like that 425 comma 5 2 one like that simply you have to add these three things after okay 32 comma 13 comma 24 comma 25 comma 5 21 you have to add like this okay so in next video I'll do it right guys but not possible today right thank you thanks for your time and uh take care guys bye