LOGICAL MIS INPHOSIS-4(17-18)

Key Takeaways

sorry guys actually this is the logical uh logical query for the post of miles and here i will i'm going to share the solution for this and it's very very important uh and i don't want to don't want to reveal the company name and i'm going to cover two queries because i'm having a busy schedule in that pc of digi schedule so i'm trying to explain you these type of queries so i'll i request everyone to like share and subscribe my channel and here is the query so first of all what you're doing you hear names or cases whatever i'll explain you we have to find the age by using the vlookup for the person those persons are case sensitive we have to find the perfect eight person so what i'll do here first of all find find will look up only uh case and two if it is smaller it will pick up the smallest that is not a case since it will pick up small a and capital a also but find will pick up only the case sensitive characters so what i'll do find this comma in this area locking all sides f9 so it will evaluate and it will show you what happened here is showing wrong thing right yes it is the right thing because small j is available over here see so it is pickuping that position and semicolon means columns sorry rows and uh column means columns column means columns it's a semicolon let me call it let me call them semicolon okay so what we have to find we have to first of all we have to read off the errors and we have to pick up that number so what you'll do is we use e's number is anything number over here sorry where you would find the number it will pick up that thing so i am using vlookup see how we are doing excuse it's an array constrain one comma two comma and this is the first value and we have to find the second value okay open another bracket close flower bracket here these are the index we are telling choose function to pick up both things which is why it will pick up one we are asking in the tooth function to pick up both things so it's called an array constraint so value one is over this is the value one and this is the value to where we are pick upping the age from this range f4 close parenthesis still here it is over see what will happen if i play a vertical i'll press enter see what will happen f9 see false 53 was 54 so 41 false 41 true 72 so we are interest only in true not in forces so vlookup will pick up the first occurrence value so what i'll use we look up true comma here come to the end comma second zero now it's an array function you have to use ctrl shift and enter drag from the killer that's it if you have any doubt ask me in the comment box i'm ready to explain you again and here coming to another solution this is logical of my interview question so please keep concentration on this and you have to find those names but they are case sensitive okay these are the functions you can use in 2010 from 2010 i'm not i'm not having an idea on 2007 but i'm giving a students that you can use this function in 2010 actual 2010 version okay so first of all we have to extract each and every letter from this value rho indirect length we doesn't know how many characters so we are using starting from one to total length of the characters total uh length of the character it may be three it may be five it doesn't know for that reason i'm using length function over in the indirect function i'm closing all parentheses pressing f9 see it is showing small c capital z starting from one to three it is pickuping three and here observe guys semicolon means rows semicolon means rose so it is rose okay now what you have to do you have to extract so what i'll use i'll use made of this comma come to end comma each and every characters i want three characters from each and every character so i press f9 c describe each and every character now see the magic find of those things see first of all observe in this but it will not work guys why i'll show you see it will not work it will not work so what i'll use here we are setting in columns and using row function for that today it will not work so what i'll do i'll convert this into a columns by using transpose function come to end here this thing okay transpose function f9 see here you can see how many are available here five total three we have to find here five five and seven okay so we are interested in numbers not in the value address or some other that you're interested in number so what i'll use here whatever press enter i'll move a little bit so that you can see the formula perfectly f2 here again i'm pressing s9 c 5 5 and 7. okay now control z i'm interested only numbers not in errors so i'm using e's number e is number and two those things which we need to add total age of the person who are case sensitive i have four asp96 53 72 45 if you add these three things it will convert into a 170 totally okay this is a this is not at all considered considered to work for the company just they want to check your skills yes they want to get your skills for that reason they will uh wantedly they will give these type of problems to check your how you solve these type of problems when it comes okay so remember this thing first of all this is only a logical amount interview question from product i'm adding all those things close parentheses i press enter it will give you the incorrect answer it's wrong answer so what are you i'll use ctrl shift and enter okay if any don't ask me i'll this way here colon mean semicolon means colon means columns okay and coming to another one eighteenth one here what i did here i'll zoom a little bit with vlookup we have to complete we have to check with the vlookup only okay not with index or another thing only with vlookup let's find it out how to do if we get this one the car the car color then we can get it this one first of all we have to get this car color okay so i'll delete this one what i'll do first of all i'll find where it is the position of course okay sorry not this first of all you have to find what you have to find here what what it is saying which is not an indigo so you have to use indigo it's a case sensitive so you have to be very carefully you have to type and here the colors f4 now it will pick up the position wherever it is there so it is showing 1 2 3 4 5 but we are not interested indigo they are saying other than indigo which is the first occurrence of the car color so what we have to use here i am not interested in that so what i will use i am interested in the first occurrence so what i'll use okay we'll do uh is numbers see how i'll do we can use the answer of each number we'll try with either okay he's at it we'll try this one first of all latter will go to another one f9 so it is pickup this is the first occurrence so we are not interested in indigo okay the intestine uh the other than indigo what was the current okay so here what i'll do we look up we look up clue choose flower bracket 1 comma 2 comma and the second value what will the second value this one only same this one only close parenthesis comma two comma zero let's check it out whether it's working or not by pressing f9 wallet is the first occurrence other than indigo it's an array function if you press enter it will give you incorrect or errors so i'll convert this into a array by using ctrl shift and enter okay the same formula if you want to find control c escape and you want to find the rate right so what i'll use instead of uh indigo right here what i'll use i'll use the weight over here this one i put let's try by using ctrl shift and enter voila first occurrence here it is if i press if i convert this into indigo again indigo or blue something like that so what it will pick up other than indigo blue only first occurrence if i press indigo then it will pick up wallet okay are you able to understand if any doubts let me know in the comment box and if anybody wants to join in with my telegram group welcome i'll mention i'll uh give a description about my telegram group link okay thank you guys thanks for your support have a nice day