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

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

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

[rahulsarangal]

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

[Classnotes]

Bhai isme kya ham nested if ka use Kar skte h

[esharajpurohit]

How to apply such type of filter in case there is" amt dr or cr "
How can we sort dr amt or cr amt ??

[theendman]

How to get filter option in top of box. I'm talk about down ward Arrow sign

[sammystarfish]

Your style of explanation is just brilliant👍

[Silent]

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

[Tejasri]

Bhai kehna kya cahte ho....kaha se ate ha aise log😂

[BlazONgaming]

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

[pramodkr]

Filter ka sign kaise aya phle ye to btate
Jise nhi ata vo yhi sochta rhega ki ye sign kaise aya

[googlebaba]

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

[AmySharma-cygx]

Galat .. filter krne k vad jab ctrl d kroge toh alt+; press kroge tabh aaega

[dushyantraja]

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

[ak.sigmarool]

Bhai pata tha 😂😂 video pura nahi deha hu

[urmilakumari]

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