MARCH REAL MIS 1

Key Takeaways

two comma name okay raak okay to come as per formula it has to come previously in previous video I explained how to find the four sorry not four first name and last name how many are there you have to count yes sir here three names are there middle first name and last name here you have to find only the first name okay guys here see first of all what you have to do here means you have to we look up first thing okay first of all you have to do we look up okay we lookup we get this one right but we want to split in different columns sorry different rows as per team leader so what I'll do there is a function mid substitute of comma perent we want that uh letters we want that value yeah F4 comma this one F4 comma 2 comma 0 okay so we brought we brought that value from the data okay now that part is over now coming to next part what will be the old text old text will be the comma and what will be the new text so I am adding a space that two maximum number that is 255 you can you can type 100 also there is no issues but maximum 255 times okay still here anybody I think understood I'll show you I'll show I'll show you number of characters when I type 1 into 255 comma 255 and it it will give you all the spaces first of all okay wait a minute close parenthesis F9 so it will pick up only the one when I type two instead of one it will give you second name okay as per I I have taken this one now from from that value it is doing all this things so what I'll do here simply I use a rose function G23 colon G23 that's it okay simply I'm doing Enter control D come on Anand for name one name to Exel Guru if I change a to e automatically change okay we will add some name over there let's see let's see not for ye okay okay when whenever whenever we add a new name it will reflect in the output and uh I think everyone understood this one wait a minute I will wait a minute because simple formula I'm not doing any extra simple formula previously in previous video I explained how to find the four sorry not four first name and last name how many are there you have to count yes sir here three names are there middle first name and last name here you have to find only the first name not yes yeah go ahead uh uh you have put three stars okay yes because uh uh three name having name having one 2 three name middle name or first name and last name plus middle name okay okay just watch the screen is it right or another one yes sir yes sir this is this is my question is uh total seven numbers seven numbers seven names seven names seven names yes you telling about this I think so H overall overall sum of 3 to 10 R number 3 to 10 overall it's seven names list list no no no no no 8 I a eight okay ah if you want you can count it one 2 3 4 5 6 78 okay okay okay okay okay what uh three name having first middle and uh last name that's why we are uh well in Formula uh three time star yes and one time two yes uh okay but but uh if list is more than seven names for example 10 100 to 120 in that case yeah okay you okay okay okay because data is limited be counted manually 1 to three having first middle and third name but if yes data is larger form in that case yes yes I mean you mean to say that here it is the short thing with only data so we are counting it me yeah yes sir yes yes yes but if data is more than 100 200 maybe more than larger see here first of all I'll explain the concept then you'll able to understand only this formula only this formula applies to more than 100 data okay no need to worry about that okay okay okay done sir why why let me explain you why why it works because here here I mention that two spaces and three words okay two SP two star for two two stars is for two spaces yeah two star two star is for one SP okay okay two spes okay so we are what what actually it's happening means it is checking how many three words are there okay wild card yes yes okay okay yeah yeah ask ask me if you have doubt ask me no need to worry don't don't don't no no uh I was thinking that you have counted uh out of seven or eight names list 1 2 three okay okay I was thinking that three star is for that one no no no no no actually what is this meaning means there is something after that something after that something that is called wild card I think yes yes wild card that's that's I'm doing okay okay okay the it should be three words in three words two spaces yeah yeah I remember in my company for example three person having name rakes his first name is XY Z and last name is XY Z but I have to count uh only raakesh how many person having rakes or uh total of their salary or X anything we put star then then name ra Then star it will to all name having ra common yes yes yes right right right right okay okay I okay now I'll show you how to count one okay okay only one only one name it may be a middle name it may anything we doesn't know only Ur only one okay here also we are taking the world card not equal not equal observe clearly what I mean to say and start space start what we are telling here we are telling that it should it should be it should not two it is not equal to more than two words with one space okay there will be two words one space so we we don't want two words and one space okay it is one okay cria is having only one name one word name okay understood the concept which I explained you yes sir yes sir sir and have you yes go ahead go ahead uh we are having this one okay yes okay how many times space is coming okay so you tell me I will type it you tell me I will listen I understood what you what you mean to say that if you find Space if you find Space we don't want space without space we need the word oh yeah okay okay but it will not work okay done actually my is not not so much I learning no no no need whatever the question you are asking 100% correct only what I'm doing what I'm doing just I'm typing like this okay I want single I want single word okay I want single word a okay but it but it will give us eight yeah yeah understood yes yes yes each and every word it will check so we have to do like this okay to find only one word name done understood yes sir and have you have you tried that one which I posted in that telegram no no actually I have to present some reports actually monthly