FIND GENDER IN EXCEL USING FORMULA

How to use excel function to check the gender from a name? II Excel Tip and trick II My Excel Tutor.
In This video, you will learn How we can easily find the gender of person from a name data?
In this task we have to find the gender of a student name which is given in this data table and we have to write the Gender of every student.
In this video i have used a combination of these three formulas:
1.Search Formula (Case In-Sensitive formula)
2.ISNUMBER Formula (which check whether the coming result is a Number or not. If YES than it Gives True Otherwise It gives False.
3. IF Formula (For Showing the required result we will use the Logical Test formula IF Formula)
Formula used:-
=IF(ISNUMBER(SEARCH("SINGH",C13)),"MALE",IF(ISNUMBER(SEARCH("KAUR",C13)),"FEMALE","_"))
change this cell reference C13 according to your name data value.
Download this Practice File:-
docs.google.co....
See Similar video But Other for all Religion name:
How to find The gender of person in excel new updates II Find gender in excel using Vlookup formula
• How to find The g...
Most Popular videos of my channel,
How to use if formula in excel?
• How to use if for...
Subtotal Basic Part 1 Video Link -
• How to Use Subtot...
How to change text into upper case,lower case proper?
• #upper #lower #pr...
How to remove extra spaces in the text or how to use trim formula?
• #myexceltutor How...
How to use Vlookup formula in excel?
• How to use Vlooku...
if You are computer user, excel user, ms word user, power point user, and want to learn computer tips & tricks in hindi, excel tips and tricks, excel secrets, excel shortcut tricks, excel formulas, office work in excel, ms word tips & tricks, power point tips, computer technology ,then must visit our channel My excel tutor and subscribe.
___________________________________________________
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
𝗣𝗹𝗲𝗮𝘀𝗲 𝗦𝘂𝗽𝗽𝗼𝗿𝘁 𝗠𝗲 𝗙𝗿𝗶𝗲𝗻𝗱𝘀 & 𝗦𝗵𝗼𝘄 𝗬𝗼𝘂𝗿 𝗟𝗼𝘃𝗲 𝗕𝘆 𝗟𝗶𝗸𝗲 𝗦𝗵𝗮𝗿𝗲 & 𝗖𝗼𝗺𝗺𝗲𝗻𝘁𝘀
𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)
___________________________________________________
Hope you will like the video. Thanks For Watching Friends.... Have A Nice Day...
Useful Videos:
Top 11 Exce; Keyboard Shortcut Keys ►
• Top 11 Excel Shor...
All Date And Time Function In One Video:►
• #pivot #excel How...
How to use Pivot table In excel step by Step Full Tutotial ► short.gy/pzLixe
Kinemaster Video Editting Tutoial :
• Kinemaster video ...
My excel tutor Playlist's:
Five Minutes Excel Lesson Videos► t.ly/7WGj
Excel Tips & Tricks ► short.gy/3dzEvT
Subscribe to My Excel Tutor ►
/ myexceltutor
Like my Facebook page ► short.gy/RTO9X3

[@Sandhu_gaming]

👍👍👍