DELLOTTE TEST INTERVIEW

Key Takeaways

hi friends this is Excel Guru rajinikant and this query from the reputed company from India actually this is MNC company so here I'm going to share a solution and I will and I will explain you the why what are the things we are using in what way we have to use what is the function all those things we will discuss now and now I'm sharing this screen right so actually the interviewer he may be he or she interviewer HR or manager whoever it may be but wantedly intentionally they made us confused here we can use one thing observe guys here we can use countif also countif and countifs also countif wantedly he mentioned qu to make us confused that's it nothing more than that okay here I'm sharing the solution let's check it out count okay we'll take count comma what we have to do here is the logic that we have to use while card what what the wild card you have to use okay so here I'm mentioning this thing okay pick up all the uh text okay here pick up all the text from there so okay I'll let's check it out pick up all the text see toally six are so we doesn't need that one right we don't need that one okay already if if we will use counter it will pick up the six but we need only one thing that is we need only one word it may be a first name or aame middle name and last name okay so here see what I'll do now just I use another wild card that is no need of that double quotes St space that's enough okay double puts that's enough F9 see okay means what it is showing it is showing that all the text it may be available uh two words or one words totally six are then what is the four here the four is the thing which is having single space with two words the single space with two words it is considering this also three words okay it's coning this also 1 2 3 and four okay so here we have to use one function 1 comma -1 F9 6 - 4 obviously it is 2 this is the logic okay I used count it will work count if also because only one criteria is there not more than that actually is having more than one criteria but I'm clubbing in one okay for that reason it is enough one is enough okay so here use some product spell mistake come to end close parenthesis enters one two [Music] three two words one word okay we need one word now one word one word one word okay for two words same procedure okay we'll try like this okay we'll try like this comma FL bracket double quot we need two words okay just check it out it will work if it is work then well and good okay I'm I'm telling the count function to give output with two words with one space for see this is also considering 1 2 3 4 see so we doesn't need this one okay we need one 2 three only but not this one okay this is the thing so what you have to do you need two words okay so what I'll do I three F9 now easily you can use same pattern that is into 1 comma -1 F9 4 - 1 okay you have any doubt you can ask me query or a doubt in this video description okay again simply use S product [Music] F2 come to end close this one close parenthesis and totally three with one space and two words okay now three words is very simple simply use count if ctif or count whatever it may be both will work okay both will work it's very simple compared to other things that's it F9 okay I forgot double quotes here it is now I am asking this query two things two things I will ask you ask you one thing is highlight those one word with one color two words with with another color three words with another color right and not only that you have to extract the one word like here like here two words like here three words like here okay this is the again I'm explaining you have to highlight with a color as for this criteria means if it is if the word if uh what you'll say if it is having two words then it should highlight with any other color different different colors for each and everything for two words you have to color with one one color and three words with another color one word with another color okay guys this is the query uh I have to do my work okay lat I will catch you up guys and please like share and subscribe my channel thank you thanks for your concern and J sham