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)

[@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

[@yuva6270]

Raju Pathak is female 😂

[@AbhijeetjiTechnical4M]

Yes by mistake

[@yuva6270]

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

[@shalusingh7793]

😊

[@shalusingh7793]

Rrrrr

[@ican615]

😂😂😂😂

[@angadsingh5893]

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

[@gouranshprabhat4210]

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

[@sammystarfish6607]

Your style of explanation is just brilliant👍

[@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

[@kavitasharma2892]

is mai list wali trick bi use kar skte hai

[@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]

😅😅😅😅

[@rohantechnology6657]

Filter lga kr saparate kr skte h 30 second me

[@intezarkhan889]

Sabhi female hi dikh rhe hain 😂

[@user-rt8jv1hi5o]

Thanks

[@SUNILGOYALPOWERMAN]

good teaching

[@satishmohle8649]

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

[@Mlbb_Nothing_Gaming]

if formula used karna par ho jay ga

[@AnujKumar-dq9lf]

Plan share video of lookup and pivot

[@AbhijeetjiTechnical4M]

Already available visit our playlist

[@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]

😂😂😂

[@completechill0019]

वाह मौज कर दी

[@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

[@RA-kd3ne]

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

[@wasifullah1772]

So cool

[@gouravparjapati04]

Op Brother

[@arvindpandey8793]

Nice

[@zahidkhalid1726]

Neem Hakeem khatra jaan

[@bikashbantawa7873]

❤❤❤

[@88rakibmondal59]

It's Only applicable when the name starts with Mr. Or Ms.

[@TechnicalJunaid2]

apni tu khud he nhi kia

[@fit_shaha]

Are Esme to sb m female hi a rh tha

[@user-ht9ts9ji1y]

Use the flash fill 😂😂😂😂

[@paragchopade7104]

Gadbad kar di aap ne bhau

[@AbhijeetjiTechnical4M]

Name type karne mein gadbad ho Gaya sorry

[@Soorma_vlogs]

Mujhe to kuch change nhi lg rha h

[@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

[@cricketxyz2863]

Bhai isme kya ham nested if ka use Kar skte h

[@AbhijeetjiTechnical4M]

Yes

[@vickyvikas3033]

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

[@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

[@wassaysarwar]

awaz ki quality theek krly bhai!

[@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

[@user-xc1tl9qm6u]

Kuch to galat h bhaiyo😅😂😂

[@AkshithShetty93]

Filter laga kar "Mr" type karo

[@ABHISharma-pf1xn]

🎉

[@asifshekh9311]

Ladki jo video me aayi thi uski link bhej do

[@Rishabhshuklamusik]

Bhai tab ni press kiya 😂

[@user-iu3xj5ki2d]

Are Raju sabhi log female nahi hai

[@abuzarshaikh4583]

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

[@coolmonteria650]

sum if ka to rojgar hi khtm krdiyw

[@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

[@Pujasharma-dj5yh]

Aap vdo konse software se edit krte hai

[@AbhijeetjiTechnical4M]

Kinemaster

[@Himanshusharma-jg6vf]

Bhai simple mr lagata to bhi aa jata 🙄🙄🙄

[@queentannu8731]

Pura female hi agaya Usme kya hai. ?

[@gouranshprabhat4210]

🗣️👂🧠🎯👍🙏📝

[@livepromotion]

😅😅😅

[@hell4667]

i would prefer if & or function

[@AbhijeetjiTechnical4M]

Yes you can do it

[@AkhileshKumar-rt9yn]

Wrong treak bta rha hai bhai

[@NageshPrajapati-uk4cw]

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

[@VijaykewatRaj]

Apne isko record kese rka

[@AbhijeetjiTechnical4M]

Software se

[@seemasharma-ss03rc]

Amazing

[@ak.sigmarool3309]

Bhai pata tha 😂😂 video pura nahi deha hu

[@Ranigupta-2]

Esme to sb male bhi female ho gye ops

[@AbhijeetjiTechnical4M]

By mistake

[@mrkhan7567]

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

[@D3nsebgmi]

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

[@AbhijeetjiTechnical4M]

Nothing by mistake

[@Tarasho]

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

[@AbhijeetjiTechnical4M]

Not possible

[@sinister534]

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

[@AbhijeetjiTechnical4M]

Not possible

[@SurajME-jv4uo]

SB ka female kaise kr doge yarr

[@AbhijeetjiTechnical4M]

By mistake

[@AmitTiwari-st9bb]

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

[@AbhijeetjiTechnical4M]

Not possible

[@SonuKumar-ru9sx]

Formula nhi laga tujhse

[@chitransh2805]

Problem in sheet MR MRS MS

[@AbhijeetjiTechnical4M]

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

[@jamie7546]

Promo`SM

[@sumitra87]

W😂😂😂😂

[@googlebaba859]

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

[@AbhijeetjiTechnical4M]

Not possible

[@RaviKumar-ou1ss]

🤦‍♂️🤦‍♂️

[@durookgaming8539]

niraj kumar also female

[@user-yi9ug6zm8o]

❤❤❤❤❤❤❤❤❤

[@sandypatil3559]

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

[@avinashmali5603]

Bhai pehle tu thik se sikh le

[@AbhijeetjiTechnical4M]

Ok dear sikh loonga

[@priyamaurya5727]

😂😂😂😂

[@user-hu1xq3uc7c]

m

[@rakeshkamat4651]

Bhai sare female hi h kya

[@AbhijeetjiTechnical4M]

By mistake

[@vatsalshah7606]

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

[@anshuyadav8448]

Kewal ek hi ho paa rha h

[@AbhijeetjiTechnical4M]

Doing some mistake

[@Amazeproductions158]

Cajajajajaj

[@broken1994]

Mr aur Ms nahi hota toh

[@AbhijeetjiTechnical4M]

Not possible

[@urmilakumari5670]

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

[@AbhijeetjiTechnical4M]

Yes by mistake

[@neelurathore111]

अगर ms na lagaye to 😂😂

[@AbhijeetjiTechnical4M]

Not possible

[@s.munique]

Bodbak

[@satyaranjansahoo3692]

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

[@AbhijeetjiTechnical4M]

By mistake

[@MeenakshiSharma-ut9zf]

Raju Pathak feamle hai kya 😂

[@AbhijeetjiTechnical4M]

By mistake

[@user-xl9nt2vl4f]

Every male also dragged Female

[@AbhijeetjiTechnical4M]

By mistake

[@amitroy3067]

😂😂

[@amitroy3067]

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

[@user-mb7mj2ok6s]

🙇🏻 par yaha to sab female hi hai

[@AbhijeetjiTechnical4M]

By mistake ho gaya hai

[@suryavlogs8457]

All female hogeya faltu tricks

[@Palestine909]

Bhai tujhe khud nhi ata 😂😂

[@animus88888]

all female ho gayi 😅😅😅😅

[@AbhijeetjiTechnical4M]

Yes by mistake sorry

[@debleenaacharya9627]

Sab toh female hogaya bhai ye kya mazak hai 👀

[@AbhijeetjiTechnical4M]

By mistake

[@kartikmehra4538]

sab female h

[@AbhijeetjiTechnical4M]

By mistake

[@Akash_657]

Galat

[@vikkimusic5374]

Wrong ho gaya

[@AbhijeetjiTechnical4M]

Yea

[@PyarBhariDuniya-]

Hat be 😂😂😂

[@abhaprajapati7529]

Male or female sab female waah kya vahiya knowledge h

[@AbhijeetjiTechnical4M]

By mistake

[@iTheOnlyMe]

What if Mr or Mrs is not written😑

[@AbhijeetjiTechnical4M]

Then not possible

[@Fun_diary_sanjay]

Bhai drag karoge toh mistake ho jayega, ctrl d karo yea flash fill karo.

[@sahdev110]

​@@Fun_diary_sanjayok thankyou bhaiya 😊

[@Sns0194]

Ye to roge nubar he😂😂

[@AbhijeetjiTechnical4M]

😅

[@sakshijain8556]

Haha khud ko ata nh n hum jaise beginners ka majak uda rh hai , iske liye phele coloum select karna hota hai fir data validation mein jana hota hai then list choose karna hota hai usme source mein male , female likna hota hai fir hum choose kar sakte hai kuch bi batate hai

[@nirupariya3418]

Bekar