real MIS -3

Key Takeaways

hi friends this is once again rajinikant Amaya's Guru and here I'm going to share a solution for this this query already I asked in WhatsApp group how to find first urrent of a value it may be a number or it may be a character it doesn't know just we have to find first occurrent of value see if it is a text okay we can find it out if it is a number we can find it out either do is a number and so 75% are failed 75% interview or fail fail so here we will find to know you better now coming back to this formula see what I did here try to understand first of all what I'm asking King is here it may be two things anything we doesn't know that is a character if it is a character means you can use ease text E text okay if it is a number we can use ease number but we doesn't know which one it is there so which one it is there so we have to find the first occurrent or I said in previous video what is the when we will use a plus sign and when we will use asri that is multiplication sign here it is now I'm showing here it is EAS number right anything so I highlight and it will pick up see what it will pick up it will pick up like this right is go row of row of this okay F9 so it will pick up like this so we need a minimum why why I'm using minimum over here function so it will pick up the minimum function that is six okay done now function address function address function so now it will comma but by default it will take see I press enter F2 f99 okay okay column number four either column number four either row number six okay observe here guys automatically it will show you the curly brackets when I press a special key stroke that is control shift and enter double click text and numb Z right 1 and 1 equal to 1 + one it's an or function it's an or function and here 1 into one here is equal to enter see what I mean to say here and either zero pleas I'm ready to answer okay in the comment box or in my in our sh group you can ask me doubts J