How to use FILTER function in Excel - Malayalam Tutorial

[@nairsunil71]

Love it. I'm already started using the filter formula. Thank you!

[@XLnCADMalayalam]

You're so welcome!

[@younuselachola]

Thank you, your are very professional

[@7378angel]

You are the best,

[@nandakumar.p9864]

I am an Excel user, Your videos are so informative and the illustrations are very simple and presentation is Super. I was a basic user, But after watching your videos I learned a lot and using it. Thank you very much. Keep posting such type of videos 🙏

[@XLnCADMalayalam]

Thank you for your kind words :)

[@divyap600]

Who is the perfect trainer...voice clarity no words...

[@gkghpd]

Your video is very useful for both excel beginers and expertize.Keep it up

[@XLnCADMalayalam]

Glad to hear that. Thank you :)

[@abdulsamadah]

Your way of explanation is awesome. Loved it. Your videos have been part of my life. Thank you

[@XLnCADMalayalam]

Glad to hear that😀

[@SuperJaice]

Excellent class.. Thanks for sharing...

[@XLnCADMalayalam]

😀 You are welcome!

[@anantharamaniyer9936]

Wonderful and must know function. Thanks for sharing..

[@sedeeckpalot8891]

Thanks for our effort to teach excel

[@XLnCADMalayalam]

My pleasure :)

[@sajadabbas]

Today i have tried this.Very helpful.Thank you so much😍

[@XLnCADMalayalam]

My pleasure :)

[@bijumohan2405]

Very precise and clear narration 🙏🙏👍🏽👍🏽👍🏽

[@XLnCADMalayalam]

Thank you :)

[@vijeesht6181]

Excellent teachings thank you

[@XLnCADMalayalam]

Glad to hear that 😀

[@ameenpk1572]

Very powerful function. വളരെ വ്യക്തമായും കൃത്യമായും വിഷയം അവതരിപ്പിച്ചു തന്നതിന് നന്ദി.

[@XLnCADMalayalam]

My pleasure :)

[@royphilip8486]

👍 Very Good Explanation

[@XLnCADMalayalam]

Thank you :)

[@nahilka9505]

Hi sir I learn Excel by watching your video

[@XLnCADMalayalam]

Glad to hear that Nahil :)

[@ZachKurian]

Very good

[@vishnup8977]

Ee function Vere level 💥💥💥

[@XLnCADMalayalam]

Yes 😀

[@kmanoj392]

Powerful thank you sir

[@XLnCADMalayalam]

My pleasure :)

[@infact5376]

Great as usual!

[@XLnCADMalayalam]

Thank you :)

[@mohammedshuhaiba.v.6298]

Well explained

[@XLnCADMalayalam]

Thank you :)

[@ajmalmohammedali3173]

Thanks, it was a good presentation.

[@XLnCADMalayalam]

Glad you enjoyed it!

[@jayasankars5173]

സൂപ്പർ.....

[@XLnCADMalayalam]

Thank you :)

[@younusk5501]

Powerful information 👌

[@XLnCADMalayalam]

Glad you think so!

[@bkaladi1483]

Excellent 👍

[@XLnCADMalayalam]

Thank you :)

[@sadikpazhankave5286]

Very interesting. Thank you very much. (Sadik- Doha Qatar)

[@XLnCADMalayalam]

My pleasure :)

[@jimshivijeeshjimshivijeesh9531]

Chetante class adipopoli

[@antowilson8040]

Very helpful videos, really appreciate. Daily expenses and revenue recording with weekly, monthly and yearly summary using excel; also video on excel dashboards would be really helpful.

[@XLnCADMalayalam]

Thank you for the suggestions :)

[@sulfikarIAS]

Great classes ❤

[@XLnCADMalayalam]

Glad you think so 😀

[@jayeshlal1975]

EXCELlent !

[@XLnCADMalayalam]

Many thanks!

[@mohamadsafwan4575]

Thanks...........

[@XLnCADMalayalam]

You're welcome!😀

[@bpshameer]

Please check 16:31, here you intended to get all senior managers from the table, but it shows other designations also. Why?

[@XLnCADMalayalam]

Watch from 14:42. Here we are filtering data with an OR condition. Either 'Technical Department' or 'Senior Manager' position.

[@jothishkumar722]

വളരെ പ്രയോജനമുള്ളത്.... Pivot table, vlookup ഇവ ഇതു പോലെയല്ലേ?

[@XLnCADMalayalam]

I am curious. What makes you think that PivotTable, VLOOKUP and FILTER function are same.

[@Rajeshgodsown]

Nice presentation. Can you do a video on "Disabling CUT". COPY & PASTE are not to be disabled. When a part of an INPUT RANGE is being cut & pasted to another part of the same range, the cell references in the formulae are getting changed (Even after using absolute references). Insted of CUT & PASTE, if we use COPY & PASTE this fault won't happen.

[@ksrraman]

Very Useful!

[@XLnCADMalayalam]

Glad you think so!

[@ababu9862]

Super super super

[@XLnCADMalayalam]

Thank you, Thank you, Thank you 😀

[@suhail368]

Hi ,can you please share a video of power apps ?

[@XLnCADMalayalam]

Thank you for the suggestion :)

[@jafarabdu3398]

Great

[@XLnCADMalayalam]

😀

[@mohamadriyas4123]

Super

[@XLnCADMalayalam]

😀Thank you

[@hashimrahmanofficial]

10:33 ... Without closing brackets how it works ??

[@XLnCADMalayalam]

Try it yourself👍

[@sreejithsreelal2756]

Thanks sir

[@XLnCADMalayalam]

My pleasure :)

[@sethumohanlal1738]

How can it be so powerful when we can simply use drop down filter?

[@rajesh300982]

ഈ ഫോർമുല ലഭ്യമായിട്ടുള്ള വേർഷനിൽ നിന്നും ഈ ഫോർമുല ലഭ്യമായിട്ടില്ലാത്ത വേർഷനുപയോഗിക്കുന്ന ഒരാൾക്ക് ഫയൽ അയച്ചു കൊടുത്താൽ എന്ത് സംഭവിക്കും? ഫോർമുല റിസൾട്ട് ഫയൽ കിട്ടിയ ആൾക്ക് കാണാൻ പറ്റുമോ?

[@gkghpd]

Filter fuction first google sheet il undarunn

[@uaediariesvlog4445]

Ee same excel il kure koodi date undengil. Ex :- empolyee number, name, desgn, sal, passport no, iban, date of join, hra, ta, angane kure details. Appol employee number type chaiyumbol ee full details il ninnu namuk name + passport no + salary. Engane 4..5 head details matram ayi seperate ayi disply akkan equations set akkan sadhikumo.

[@reghuknair9488]

Formula discription box ൽ ഇടുമോ

[@haseebk313]

ഈ ഫിൽട്ടറിംഗ് വേറ മെത്തേടിൽ ചെയ്യാൻ പറ്റുമോ ms ഓഫീസ് 2016 ൽ വർക്ക് ചെയ്യുന്ന മെത്തേട് ഉണ്ടോ ഒരു വീടിയോ ചൈതാൽ വളരെ നന്നായിരുന്നു.

[@XLnCADMalayalam]

The FILTER function is available with Excel online (free to use), Excel 2021 and Google Sheets. You can also try the Advanced Filter in Excel. Go through my video on this topic.

[@SS-oy2dv]

Sir പുതിയ എക്സലിൽ ഫിൽറ്റർ ഫോർമുല കിട്ടുന്നില്ല...

[@XLnCADMalayalam]

Please watch the last portion of the video to know about the versions of Excel that have FILTER function.

[@nivinvincent8498]

ഫിൽറ്റർ function ഇല്ലാതെ ഒരു search box create ചെയ്ത് ഫോർമുല ഉപയോഗിച്ച് data ഇതുപോലെ filter ചെയ്ത് എടുക്കുവാൻ കഴിയുമോ

[@hashimrahmanofficial]

❤

[@Gogreen7days]

ഒരു row select ചെയ്യുകയാണ് . 500 lines und. അതിൽ some columns formula ഉള്ളത് ഉണ്ട് ഇല്ലാത്തതും ഉണ്ട് . എങ്ങനെ നമ്മൾക്കു formula ഉള്ളത് highlight ചെയ്ത് കാണിക്കാൻ ഒക്കും .. please advise Thanks

[@lorancemathew]

Sir, I have purchased your course. It is very useful. I am using windows 11 and office 365 I think. Laptop is new one and OS is inbuilt one. But this filter function is not seen here, only FILTERXML function is here. What can I do. Please give a reply

[@XLnCADMalayalam]

FILTER function and 8 new Dynamic Array Functions are a part of Excel with Microsoft 365 (previously known as Office 365). So check make sure that you have Microsoft 365 subscription.

[@anooppaikkattumani]

1-10-2021 to 31-10-2021 1-10-2021 to 30-11-2021 1-10-2021 to 31-12-2021 1-10-2021 to 31-03-2022 ഇത്‌ എങ്ങനെയാണ്‌ create ചെയ്യുന്നതെന്ന് പറയാമോ

[@manissery1956]

Am using this function. Have a data sheet where am writing to filter items exceeding a particular amount It gives instantly. But after reopening the file and if there are more entries satisfying the condition, the values are not automatically displayed but have to write the formula again. Why so???

[@XLnCADMalayalam]

I can't figure out why that is happening. Make sure that the calculation mode in Excel is set to Automatic.

[@god7361]

Unique and filter new version kittunilla

[@yashahysh8486]

adipolii , but function lla old version aahn

[@riyazkm6460]

Excel sheetil Small letter aayi typ cheytha words enganeyan Capital letter akkan pattumnath ?

[@XLnCADMalayalam]

Please refer my videos on UPPER, LOWER and PROPER functions in Excel.

[@MubarakA]

How using excel for web

[@XLnCADMalayalam]

I have done a video on this topic (How to use MS office Applications for free). Please go through the videos section to find it.

[@unnikrishnanph1842]

I want s=1 number and letter code

[@dohanix]

Hi What if some cells in the source data is blank? When I tried it is returning a value 0.. Any hack to avoid that?

[@sareens7147]

Enikk ee function kitunila

[@XLnCADMalayalam]

Please watch the last portion of the video to know about the versions of Excel that have FILTER function.

[@anilennakkad7217]

Can we extract data of selected fields from a big data set that is huge? How do we do it? For instance, I want to get a list of names of one office location and corresponding bank account number and amount to be paid from a data set that has many other information. Is it possible?

[@muhammadalik9630]

👍👍👍👍

[@robishnp2148]

ഫിൽറ്റർ ഫങ്ഷൻ ഇല്ല

[@____SHREE____]

⭐⭐⭐⭐⭐

[@shibusadanandan9006]

❤

[@XLnCADMalayalam]

😀👍