How to use FILTER function in Excel - Malayalam Tutorial

എക്സലിലെ FILTER ഫങ്ഷന്റെ ഉപയോഗങ്ങൾ വിശദീകരിക്കുന്ന വീഡിയോ.
FILTER function in Excel, explained in Malayalam.
Intro (0:00)
1. Filter data based on a Text condition (2:45)
2. Filter data based on a NUMBER condition (7:43)
3. Filter data based on multiple conditions (11:19)
4. Filter data from a Single Column of a large dataset (16:40)
Outro (17:51)
Note that the FILTER function is available only with the following versions of Excel.
1. Excel with Microsoft 365
2. Excel 2021
3. Excel Online (Excel for web)
മൈക്രോസോഫ്റ്റ് എക്സൽ കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
www.udemy.com/course/microsof...
Subscribe to the channel for more
/ ajayanandxlncad
#ExcelMalayalam #MalayalamExcel #ExcelTips

[@anantharamaniyer9936]

Wonderful and must know function. Thanks for sharing..

[@nairsunil71]

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

[@XLnCADMalayalam]

You're so welcome!

[@7378angel]

You are the best,

[@abdulsamadah]

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

[@XLnCADMalayalam]

Glad to hear that😀

[@bijumohan2405]

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

[@XLnCADMalayalam]

Thank you :)

[@sajadabbas]

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

[@XLnCADMalayalam]

My pleasure :)

[@infact5376]

Great as usual!

[@XLnCADMalayalam]

Thank you :)

[@SuperJaice]

Excellent class.. Thanks for sharing...

[@XLnCADMalayalam]

😀 You are welcome!

[@gkghpd]

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

[@XLnCADMalayalam]

Glad to hear that. Thank you :)

[@kmanoj392]

Powerful thank you sir

[@XLnCADMalayalam]

My pleasure :)

[@younusk5501]

Powerful information 👌

[@XLnCADMalayalam]

Glad you think so!

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

[@ajmalmohammedali3173]

Thanks, it was a good presentation.

[@XLnCADMalayalam]

Glad you enjoyed it!

[@sedeeckpalot8891]

Thanks for our effort to teach excel

[@XLnCADMalayalam]

My pleasure :)

[@vijeesht6181]

Excellent teachings thank you

[@XLnCADMalayalam]

Glad to hear that 😀

[@ksrraman]

Very Useful!

[@XLnCADMalayalam]

Glad you think so!

[@mohamadsafwan4575]

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

[@XLnCADMalayalam]

You're welcome!😀

[@royphilip8486]

👍 Very Good Explanation

[@XLnCADMalayalam]

Thank you :)

[@vishnup8977]

Ee function Vere level 💥💥💥

[@XLnCADMalayalam]

Yes 😀

[@jayasankars5173]

സൂപ്പർ.....

[@XLnCADMalayalam]

Thank you :)

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

[@jimshivijeeshjimshivijeesh9531]

Chetante class adipopoli

[@jayeshlal1975]

EXCELlent !

[@XLnCADMalayalam]

Many thanks!

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

[@bkaladi1483]

Excellent 👍

[@XLnCADMalayalam]

Thank you :)

[@mohammedshuhaiba.v.6298]

Well explained

[@XLnCADMalayalam]

Thank you :)

[@sadikpazhankave5286]

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

[@XLnCADMalayalam]

My pleasure :)

[@jafarabdu3398]

Great

[@XLnCADMalayalam]

😀

[@sulfikarIAS]

Great classes ❤

[@XLnCADMalayalam]

Glad you think so 😀

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

[@nahilka9505]

Hi sir I learn Excel by watching your video

[@XLnCADMalayalam]

Glad to hear that Nahil :)

[@ameenpk1572]

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

[@XLnCADMalayalam]

My pleasure :)

[@sreejithsreelal2756]

Thanks sir

[@XLnCADMalayalam]

My pleasure :)

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

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

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

[@ababu9862]

Super super super

[@XLnCADMalayalam]

Thank you, Thank you, Thank you 😀

[@shibusadanandan9006]

❤

[@mohamadriyas4123]

Super

[@XLnCADMalayalam]

😀Thank you

[@muhammadalik9630]

👍👍👍👍

[@Gogreen7days]

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

[@sethumohanlal1738]

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

[@nivinvincent8498]

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

[@gkghpd]

Filter fuction first google sheet il undarunn

[@suhail368]

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

[@XLnCADMalayalam]

Thank you for the suggestion :)

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

[@rajesh300982]

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

[@yashahysh8486]

adipolii , but function lla old version aahn

[@god7361]

Unique and filter new version kittunilla

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

[@unnikrishnanph1842]

I want s=1 number and letter code

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

[@____SHREE____]

⭐⭐⭐⭐⭐

[@reghuknair9488]

Formula discription box ൽ ഇടുമോ

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

[@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 ചെയ്യുന്നതെന്ന് പറയാമോ

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

[@jothishkumar722]

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

[@XLnCADMalayalam]

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

[@SS-oy2dv]

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

[@XLnCADMalayalam]

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

[@robishnp2148]

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

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