counting numbers and text with creteria lenngth

Key Takeaways

here i got a call for that reason and here i asked this query in my groups that is excel online session group with this after completion of this i will ask another query after completion of this avalanche i will ask that query you have to answer that query and now i am asking that what is the length of three length numbers 37 and the text is six the length of the characters if i came to two it will come to if i change one thing if i change four is not there maximum three is there right if i change forcing not that okay so here i'm going to explain you that one first of all what you'll do length of the whole table f4 equal to this okay this is the first condition and another condition is just i want to okay first of all i press f9 to evaluate and see whether it is there or not because it's a 4 it's not there i'll suspend this formula for a while and left press 2 and i'll come back to the formula i have to come back to that f9 see wherever it finds the two length what it may be text or numbers but i want only the numbers not the text so what i'll do here another condition is that these numbers is anything number over here okay these are the two conditions if it is true and if it is number true then it will give us the true into true one true into false false that is zero see what happens f9 see how many are there one two three four and five see here simply use some product for this some product i'll copy whole formula ctrl c enter and i'll come back here f2 control b in place of ease number i will mention each text enters because i'm interested in text here if i change this 2 to 3 c 4 is not there see what i'll do i'll add another here a b and here i will add 60 okay now see the changes see text with 2 length is 5 and the numbers 2 length is six total count right and here coming to another this one that is take the age get the age by using database function see it both things should match then only it will give you the eight and get the magnitude by vlookup get the minimum eight percent name by vlookup only and if you have any queries please let me know in the comment box thank you guys thanks for your support have a nice day uh [Music]