REAL MIS -4(PART A)

Key Takeaways

she is Excel Guru rajinikant and here I'm going to show you the output for the first query for the real am 4 which I posted earlier in WhatsApp group since so many days no have been solved this query so here I'm going to show the show you the solution for that so here it is first of all what you have to do means is equal to to get the team members from TL this is F this one is TL so you have to get okay I'll make it a zoom little bit so that you can able to understand perfectly right I think everyone can able to see this okay now okay see here is the solution which I'm going to show you each and everyone please keep concentration on this this is very very important question so first of all we have to get those names team members names as per TL TL is the condition is equal to we look up see how I'll do equal to we look up this one F4 because I'm freezing see first of all before showing this I'm using Office 365 because everyone is saying that I may using 16 all those things for your confirmation see I'm using Office 365 right here I have to make it freeze that is F4 function F4 comma Now bring the data select the data again freeze it step by step I'm doing if you have any doubt ask me in the comment box comma 2 comma Z okay you'll get that name as per team leader okay you'll get that name as for team leery now you have to extract as per rowwise okay so here is the challenge so what you have to do means just whatever I'll show here just follow that one [Music] right the delimeter is comma right so what I'll do here I use a mid function to substitute of comma % so I'm adding uh comma to the value right whatever the value we have get from table we are adding a comma because comma is a delit as everyone know comma now old text what is the old text as we know that is comma comma and now what is the new text what is the new text you want to add so I use one function that is a repeat of space comma 255 times here Substitute part is over right and now coming back to the mid what I'll do here I use one function that is 1 into 255 see what magic it will come and number of characters is 255 only see what magic it will come it will not show you anything okay no need to worry it not at all show you some uh uh first of all here I'm using my laptop so here there is no F9 function key function key is the F9 but it will not work in laptop I think so let's check it out yes it's working name5 okay control+ Z now I'll use here a trim function to rid off Extra Spaces trim off okay here see the magic which I'm going to show you okay it's a normal function guys it's not a what ARR function it's a normal function F9 F9 name 15 okay so F name 15 see F name 15 but what about the remaining names okay you want to get remaining names right what I meant to say so what I'll do I'll do Escape come back to here F function key F to I think formula is gone yes okay again I have to use formula no need to worry F function key of two I press the wrong key so for that it is C right M of substitute of a comma I'm adding comma to this where is okay and what will be the old text as we know that is comma and what will the new text so what I'll do I'll a repeat function to add extra spaces for that comma and Substitute part is over now coming back to the mid part 1 into 255 comma 255 okay I press enter okay it's normal function it's not an array function okay so what I'll do here see what I'll do here whenever press suppose if I press two it has to give second name as per the team leader f name 16 is there okay Enter got it so what I'll do here I will use a dynamic function R of the formula in G dollar3 G3 so I'm locking the row but not the column G dollar 3 col D3 close parenthesis function is over that's it now double click you able to see okay the extra spaces so I forgot to remove that Extra Spaces here you have to use Extra Spaces here so use trim function to R of to remove Extra Spaces that's it it's not noral function it's not an AR function it's a normal function and double click over here where it is see what's wrong here what's wrong here see here I did one mistake for that is showing like this function key F2 here why I used one here no need of one here okay okay guys I'll be back with lots more interview questions this is a dynamic way thank you guys thanks for your support and