How to Use Filter Smartly in Excel | Excel Tips & Tricks

How to Use Filter Smartly in Excel | Excel Tips & Tricks

[@sayndrape9469]

Instead use a formula =IF(LEFT(B4,2)="Mr","MALE","FEMALE")

[@munir8779]

​@@XyZy-dx3wgSame Butt Without Formula Man Is Nothing😢

[@sabeelahmed1157]

Mrs ko bhi Male bana dega ye formala😂

[@Allinone-sh6cj]

Mrs😢

[@gamingvideo261]

​@@sabeelahmed1157nahi hoga mrs me female aayega

[@jaanmohammadkhan4000]

=if(A1="Mr","MALE",FEMALE)

[@yuva6270]

Raju Pathak is female 😂

[@AbhijeetjiTechnical4M]

Yes by mistake

[@yuva6270]

@@AbhijeetjiTechnical4M learning a lot from your videos. Thanks again

[@shalusingh7793]

😊

[@shalusingh7793]

Rrrrr

[@ican615]

😂😂😂😂

[@theaveshansari]

Another way: just sort column C in alphabetical order now you have all MR and MS/MRS altogether. now you only need to type male or female in first cell and drag it to the bottom. This method is simple and will take similar time to the one shown in the video.

[@PintuKumar-fo3wh]

Correct... Video Mai toh bakwas bola zada time waste

[@MuhammadAsif-nk3oh]

Right drag column work is simple

[@angadsingh5893]

You are wrong dont drag this you have used filters. Select it use selected columns paste.

[@akankshasuryavanshi5193]

Bhai Excel itna jyda wide h ki sb kuch yaad rakhna possible nhi ho pata h shikhte rehna chahiye, aur Rahi baat ghamand ki toh sorry bro I'm not agree with you 😅 corporate wale kabhi ghamand nhi krte h 🤣🤣🤣🤣kitna bhi perfect bn lo manager kami nikal he dega 😮

[@AbhijeetjiTechnical4M]

😂😂😂

[@surendrakumar-sp4hy]

Bhai aise mt bol main bhi jhoot bol k job to paa liya bc daily insult hoti h isi wajah se actually me mujhe bilkul excel nhi aata , ab seekh rha hu😅

[@lipsamalik6077]

😀😀

[@sheenugautam6632]

Kis field mai job lgi konsi jagah

[@amirishaqui786]

😅😅😅😅

[@intezarkhan889]

Sabhi female hi dikh rhe hain 😂

[@rahulsarangal8123]

First copy data to right column and select or Use replace feature find MS* replace with Female
Same find Mrs* replace with Female
Mr* replace with Male

[@harikc872]

Friends here is the complete Solution..IF(OR(LEFT(C2,3)="Mrs",LEFT(C2,2)="Ms"),"F","M")....C2 is the Names Column......this Solution is WORKING

[@avinashmali5603]

Bhai pehle tu thik se sikh le

[@AbhijeetjiTechnical4M]

Ok dear sikh loonga

[@TechnicalJunaid2]

apni tu khud he nhi kia

[@vatsalshah7606]

Agar mr and miss kuch nahi likha hota to gand fat jati 50000 column hote ho

[@uplalganj822]

Vo to ek column me bhi female likh kar bas drag karne se bhi to vahi word copy hota hai bina filter par jaye

[@vickyvikas3033]

Ja MS likha hua h waha pe v female hi likha hua aa raha h... Check kro video ko sahi se

[@abuzarshaikh4583]

Sidha sidha filter krk samne column m ek saath likh do 🤦

[@rohantechnology6657]

Filter lga kr saparate kr skte h 30 second me

[@mohitdhruw7236]

Sir agar hindi font ho to tab kya kare jaise Shrimati & shri ya phir ladki ke liye Kumari ladke ke liye balak matlab sir balak balika kaise kare?????

[@AbhijeetjiTechnical4M]

Simple type in Hindi and do it

[@AkhileshSingh-w6n]

Use the flash fill 😂😂😂😂

[@VijayKumar-b4z1b]

Are Raju sabhi log female nahi hai

[@Shailesh7647]

Mr. Explainer,
Filter karne ke baad , Drag nhin karte Hain kabhi bhi,
Control+D use karte hain

[@AbhijeetjiTechnical4M]

In office 365 easily you can drag it will calculate automatic
Here I have done another mistake that’s why result is coming wrong

[@Akihsnav-u8q]

Kuch to galat h bhaiyo😅😂😂

[@Soorma_vlogs]

Mujhe to kuch change nhi lg rha h

[@Akash_657]

Galat

[@Palestine909]

Bhai tujhe khud nhi ata 😂😂

[@AkhileshKumar-rt9yn]

Wrong treak bta rha hai bhai

[@vijayyadav4042]

To itna andar jane ki kya jarurat hai jitna tum waha kiya utna hi male female likh jaata 😂😂😂😂

[@fit_shaha]

Are Esme to sb m female hi a rh tha

[@Ranigupta-2]

Esme to sb male bhi female ho gye ops

[@AbhijeetjiTechnical4M]

By mistake

[@livepromotion]

😅😅😅

[@abhaprajapati7529]

Male or female sab female waah kya vahiya knowledge h

[@AbhijeetjiTechnical4M]

By mistake

[@sumitra87]

W😂😂😂😂

[@gouranshprabhat4210]

Sir, please make a video on topic of date edit as per our need. 🙏

[@PyarBhariDuniya-]

Hat be 😂😂😂

[@Amazeproductions158]

Cajajajajaj

[@sandypatil3559]

Fir to tuze b excel nahi aata theek se. Itna b nahi karna padta hai 😂

[@AnujKumar-dq9lf]

Plan share video of lookup and pivot

[@AbhijeetjiTechnical4M]

Already available visit our playlist

[@gouranshprabhat4210]

🗣️👂🧠🎯👍🙏📝

[@D3nsebgmi]

🗣️: Miss & miss is mai ky diff h ☠️

[@AbhijeetjiTechnical4M]

Nothing by mistake

[@chitransh2805]

Problem in sheet MR MRS MS

[@AbhijeetjiTechnical4M]

Grt ,no one could find right problem
Saying this is wrong method

[@ColorsOfZindagi]

Jaa beta pehly khud atchy sae seekh kr aao.

[@AbhijeetjiTechnical4M]

Ok sir Sikh loonga

[@GuriDhawan-f5f]

m

[@asifshekh9311]

Ladki jo video me aayi thi uski link bhej do

[@mrkhan7567]

Aare mere bhai isse aasan h ki =IF Condition use kar lenge itna jhamela me jane aacha

[@RaviKumar-ou1ss]

🤦‍♂️🤦‍♂️

[@NageshPrajapati-uk4cw]

Male lakhelo avto nathi
Female j lakhvu hati to dreg karvi hatu female. Male to lakhelu avtu nathi

[@priyamaurya5727]

😂😂😂😂

[@queentannu8731]

Pura female hi agaya
Usme kya hai. ?

[@vickypirates]

Agar male ko manually hi type krna hai to ek baar female type krke dubble click krna pura niche tak female type ho jayega itna taam jhaam kyu 🥱🥱🥱🥱

[@AbhijeetjiTechnical4M]

You can use if function to make dynamic formula

[@btsjuniorshah]

Muhi

[@SurajME-jv4uo]

SB ka female kaise kr doge yarr

[@AbhijeetjiTechnical4M]

By mistake

[@MeenakshiSharma-ut9zf]

Raju Pathak feamle hai kya 😂

[@AbhijeetjiTechnical4M]

By mistake

[@wassaysarwar]

awaz ki quality theek krly bhai!

[@s.munique]

Bodbak

[@SonuKumar-ru9sx]

Formula nhi laga tujhse

[@paragchopade7104]

Gadbad kar di aap ne bhau

[@AbhijeetjiTechnical4M]

Name type karne mein gadbad ho Gaya sorry

[@VijaykewatRaj]

Apne isko record kese rka

[@AbhijeetjiTechnical4M]

Software se

[@nirupariya3418]

Bekar

[@Rishabhshuklamusik]

Bhai tab ni press kiya 😂

[@neelurathore111]

अगर ms na lagaye to 😂😂

[@AbhijeetjiTechnical4M]

Not possible

[@broken1994]

Mr aur Ms nahi hota toh

[@AbhijeetjiTechnical4M]

Not possible

[@ak.sigmarool3309]

Bhai pata tha 😂😂 video pura nahi deha hu

[@anshuyadav8448]

Kewal ek hi ho paa rha h

[@AbhijeetjiTechnical4M]

Doing some mistake

[@zahidkhalid1726]

Neem Hakeem khatra jaan

[@Himanshusharma-jg6vf]

Bhai simple mr lagata to bhi aa jata 🙄🙄🙄

[@coolmonteria650]

sum if ka to rojgar hi khtm krdiyw

[@urmilakumari5670]

Sabhi k naam k samney female likha AA Raha hai tumhare video mein.

[@AbhijeetjiTechnical4M]

Yes by mistake

[@kartikmehra4538]

sab female h

[@AbhijeetjiTechnical4M]

By mistake

[@googlebaba859]

Jisme Mr & Mrs mention nhi hai to, waha ksie formula lgega

[@AbhijeetjiTechnical4M]

Not possible

[@dushyantraja]

Bhai agar naam ke samne Mr. Ms mrs nhi likha ho tab ghamand kaise karoge

[@AbhijeetjiTechnical4M]

Then not possible

[@vikkimusic5374]

Wrong ho gaya

[@AbhijeetjiTechnical4M]

Yea

[@sinister534]

What if there is no mr or ms in beginning of names?

[@AbhijeetjiTechnical4M]

Not possible

[@kavitasharma2892]

is mai list wali trick bi use kar skte hai

[@emaannadeem9342]

You can also use a formula
=IF(A2

[@AbhijeetjiTechnical4M]

Wrong formula

[@AbhijeetjiTechnical4M]

If(left(a2,3)=“mr.”,”male”,”female”)

[@emaannadeem9342]

@@AbhijeetjiTechnical4M my teacher has taught me this formula and it does work so I should go with it. Thanks for telling me a new formula

[@namrataverma7845]

​@@AbhijeetjiTechnical4MSir left use kyun hua h yaha p

[@arvindpandey8793]

Nice

[@AmitTiwari-st9bb]

Agr isme ms or mr na ho to what is other option?

[@AbhijeetjiTechnical4M]

Not possible

[@satyaranjansahoo3692]

Sab k sab female hi hai filter apply karne ka kya matlab😂😁

[@AbhijeetjiTechnical4M]

By mistake

[@Tarasho]

Mrs Ms Mr na likha hoto kaise filter kre mle female ko ???

[@AbhijeetjiTechnical4M]

Not possible

[@gouravparjapati04]

Op Brother

[@debleenaacharya9627]

Sab toh female hogaya bhai ye kya mazak hai 👀

[@AbhijeetjiTechnical4M]

By mistake

[@LaraibFatima-n1r]

Thanks

[@jyotimahilange8251]

Thanks

[@Mlbb_Nothing_Gaming]

if formula used karna par ho jay ga

[@Classnotes2863]

Bhai isme kya ham nested if ka use Kar skte h

[@AbhijeetjiTechnical4M]

Yes

[@durookgaming8539]

niraj kumar also female

[@RekaSihn]

❤❤❤❤❤❤❤❤❤

[@user-mb7mj2ok6s]

🙇🏻 par yaha to sab female hi hai

[@AbhijeetjiTechnical4M]

By mistake ho gaya hai

[@RA-kd3ne]

Wow...sahi me mere gamand ka aise ki taidi hogai😅
Thanks sir

[@jamie7546]

Promo`SM

[@hell4667]

i would prefer if & or function

[@AbhijeetjiTechnical4M]

Yes you can do it

[@animus88888]

all female ho gayi 😅😅😅😅

[@AbhijeetjiTechnical4M]

Yes by mistake sorry

[@AkshithShetty93]

Filter laga kar "Mr" type karo

[@rakeshkamat4651]

Bhai sare female hi h kya

[@AbhijeetjiTechnical4M]

By mistake

[@Pujasharma-dj5yh]

Aap vdo konse software se edit krte hai

[@AbhijeetjiTechnical4M]

Kinemaster

[@TechnoteamITservices]

Every male also dragged Female

[@AbhijeetjiTechnical4M]

By mistake

[@amitroy3067]

😂😂

[@amitroy3067]

Sala itna time kosis karke pata chala ms. , Mrs. Sab female hai 😂😂

[@Sns0194]

Ye to roge nubar he😂😂

[@AbhijeetjiTechnical4M]

😅

[@bikashbantawa7873]

❤❤❤

[@ABHISharma-pf1xn]

🎉

[@wasifullah1772]

So cool

[@satishmohle8649]

ha bhai मुझे bhi garv ho gaua tha ...thanks

[@aflatoonbacha3824]

Nice

[@SUNILGOYALPOWERMAN]

good teaching