MIS TEST WITH AMAZING SOLUTION BY JR.BILLGATES(ANAND)

Key Takeaways

hi friends this is rajinikanth excel guru and here i am going to show you one amazing thing and this solution is done by anand from our group that is excel online session group now i did he did one method but i will ask you the test with this session here without help or column you have to do like this without anything without hide these things [Music] one minute all right okay only you have to do like this without helper column without anything you have to do like this right whenever it's showing the mail or zoom a little bit whenever it's showing a mail it should show the mr when it is a female you have to show mrs right so i will first of all i'll remove without helper column you have to do and here i will unhide it my mode is not important right now here i will do with this okay actually here mr anand did the solution whenever it finds in a mail session may reign it should show mr whenever he's showing in the female male female range it has to show message so he did a great uh what you say great thing i call him junior bill gates he did like this match of this comma clear that's it f4 0 see what he did he did a very great thing okay very very great thing he did it really amazing uh solution by mr anand here is the test and here also one test is there i will post this file in my group if anybody wants to join in my group and below description of this video i will mention the link of my telegram group they can join with this okay here is over now what he did see that's important what he said is number ease number control enter double click because wherever it finds the number it will show the position actually method indicates this position where it fights so each number will tell is it is anything a number if it is a number it will show the two and remaining for all falses as to what you did if is a number if he's number he did his very little thing if he's a number then what you want he added like this mr space ampersand this if it is not a number then he did like this very simple thing um this is very small method he did he did not done any with a complex formula but what i am saying means if if without helper column if you find anything without help or column you have to do only this thing you have to do like this only this thing the way how you'll do i will post this file in my group if anybody wants to join in my group they can go to my video description there you'll find the link of this telegram group okay and thank you guys thanks for your support have a nice day