MIS INTERVIEW QUESTION-100

Key Takeaways

hi guys how are you all due to a busy schedule I'm unable to uh do these things okay like now I'm first of all I'll copy this one I'll copy this one Ctrl C and control B before starting the session I will show you one thing actually this is the interview question Okay so here they asked without using indirect function how can you get all those details okay all those like this when I change from name to Bob automatically it will pick up all the date of birth okay it's like 10 sales to uh name okay see all names are occurred so I want like this whenever you change the field name automatically it should get all because from the table corresponding records from the table right so I will show you how to do that work Ctrl C control V okay now I'll show you how to do that one so first of all what you will do in best of the whole data right will take a whole data as for locking both row and a column comma you need first row and the first column example I'm saying example okay so it will pick up the first row First Column when exchange from one two it will become second column but it's first row if I change to second row second column so see what did you pick up it will pick up this one date if I change a third row total there is sales rep 3 and second column so it will pick up second to 1997. see control one I'll convert this into a normal date okay see normal date so like this we need okay so what you have to do here first of all what I'll do first of all I'll use the rows function see how we are doing the rows function wave where the formula is in h dollar 13. colon hex 13 right enter Ctrl shift friendly so it will convert into a general format that is it will wrap all the this is all my mode is not working properly sorry for that control r Ctrl D okay so here it's becoming all arrows this all of a stroke is all a second row dissolute totals okay now I will show you another thing that now what I'll do here so okay so this is the road path so I am using the index function and if you have any doubt ask me in the comment box whenever I get the time I will reply and if if you anybody is having any doubts so let me know in the comment box and this is the Rose Part okay this is two-way lookup I mean the whole table not of one column it's a whole table including rows and columns the room's part is over index part is over now we have to get the caller part that is we have to use match function where it will pick up the position okay F1 locking this row but not the column blocking the row but not the column okay because whenever I copy the formula from h13 to i14 so it will correspondingly it has to move from h14 at 13 to I thirteen okay so for that reason I am not locking column comma and here you have to pick up this and make sure that the table starts from here and your your selection is also starting from here so that's it then you have to pick up from the way it started here the table starts from here and your selection also started from here so for mat also you have to start from here only not from here look up array F4 comma zero it's a normal function double it's a normal function okay it's not a array function it's a normal function when you press enter now see the magic what it will happen so pick up dates what I'll do control are copies on the right side controls to Brown Arrow control d or reference is not J so we have to remove that one because it's not there and I'll convert this into a normal date by using Ctrl shift hats and if you want the dates so go over here control one and there you can find and instead of double M you would only instead of Triple M you have to use double m okay when I change from salary suppose it to salary so it will become all salary particles when I change here the sales uh seems to make name already since uh sales only here Bob Ctrl shift has Ctrl 1 convert this into double M instead of Triple M M okay whenever you change the header automatically it will change accordingly okay this is very very important and another thing this is the query which I am asking you guys so where it is here it is see I'll Zoom whenever I whenever I change even it's like five you can pick up five kgs because it's a plural not a singular when I click one it will pick up only KD okay when when I give more than one it will pick up kgs when it is equal to one it will pick up only the singular that is kg so let me know how is it possible how can we do it without helper column okay only in unit path you have to change like 55 kgs five kgs one kg okay so this thing you have to let me know uh I'll try on it's a simple there is not a big data so make sure that you have to do by yourself it's not a big data because it's uh only four or five rows okay and try by yourself thank you guys thanks for your support and make sure that like share and subscribe my channel because I am working hard and I am giving um I'm doing my level best I'm sharing my knowledge to everyone as of I know so please I request everyone to like share and subscribe thank you guys thanks for your support