How to use FILTER function in Excel - Malayalam Tutorial

Подписаться 160 тыс.

Просмотров 41 тыс.

50% 1

എക്സലിലെ 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

Опубликовано:

21 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 102

@anantharamaniyer9936 2 года назад

Wonderful and must know function. Thanks for sharing..

@nairsunil71 2 года назад

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

@XLnCADMalayalam 2 года назад

You're so welcome!

@7378angel 4 месяца назад

You are the best,

@abdulsamadah 2 года назад

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

@XLnCADMalayalam 2 года назад

Glad to hear that😀

@sajadabbas 2 года назад

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

@XLnCADMalayalam 2 года назад

My pleasure :)

@dohanix 2 года назад

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?

@bijumohan2405 2 года назад

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

@XLnCADMalayalam 2 года назад

Thank you :)

@SuperJaice 2 года назад

Excellent class.. Thanks for sharing...

@XLnCADMalayalam 2 года назад

😀 You are welcome!

@gkghpd 2 года назад

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

@XLnCADMalayalam 2 года назад

Glad to hear that. Thank you :)

@Rajeshgodsown 2 года назад

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.

@anilennakkad7217 2 года назад

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?

@uaediariesvlog4445 3 месяца назад

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.

@infact5376 2 года назад

Great as usual!

@XLnCADMalayalam 2 года назад

Thank you :)

@Gogreen7days 2 года назад

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

@ajmalmohammedali3173 2 года назад

Thanks, it was a good presentation.

@XLnCADMalayalam 2 года назад

Glad you enjoyed it!

@bpshameer 2 года назад

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

@XLnCADMalayalam 2 года назад

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

@nandakumar.p9864 2 года назад

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 2 года назад

Thank you for your kind words :)

@divyap600 Год назад

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

@antowilson8040 2 года назад

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 2 года назад

Thank you for the suggestions :)

@royphilip8486 Год назад

👍 Very Good Explanation

@XLnCADMalayalam Год назад

Thank you :)

@younusk5501 2 года назад

Powerful information 👌

@XLnCADMalayalam 2 года назад

Glad you think so!

@kmanoj392 2 года назад

Powerful thank you sir

@XLnCADMalayalam 2 года назад

My pleasure :)

@sedeeckpalot8891 2 года назад

Thanks for our effort to teach excel

@XLnCADMalayalam 2 года назад

My pleasure :)

@sadikpazhankave5286 2 года назад

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

@XLnCADMalayalam 2 года назад

My pleasure :)

@gkghpd 2 года назад

Filter fuction first google sheet il undarunn

@nivinvincent8498 9 месяцев назад

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

@vijeesht6181 Год назад

Excellent teachings thank you

@XLnCADMalayalam Год назад

Glad to hear that 😀

@rajesh300982 2 года назад

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

@vishnup8977 2 года назад

Ee function Vere level 💥💥💥

@XLnCADMalayalam 2 года назад

Yes 😀

@god7361 Год назад

Unique and filter new version kittunilla

@ksrraman 2 года назад

Very Useful!

@XLnCADMalayalam 2 года назад

Glad you think so!

@yashahysh8486 2 года назад

adipolii , but function lla old version aahn

@mohammedshuhaiba.v.6298 2 года назад

Well explained

@XLnCADMalayalam 2 года назад

Thank you :)

@ameenpk1572 2 года назад

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

@XLnCADMalayalam 2 года назад

My pleasure :)

@sethumohanlal1738 3 месяца назад

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

@bkaladi1483 2 года назад

Excellent 👍

@XLnCADMalayalam 2 года назад

Thank you :)

@nahilka9505 2 года назад

Hi sir I learn Excel by watching your video

@XLnCADMalayalam 2 года назад

Glad to hear that Nahil :)

@anooppaikkattumani 2 года назад

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

@mohamadsafwan4575 2 года назад

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

@XLnCADMalayalam 2 года назад

You're welcome!😀

@jimshivijeeshjimshivijeesh9531 4 месяца назад

Chetante class adipopoli

@jayasankars5173 2 года назад

സൂപ്പർ.....

@XLnCADMalayalam 2 года назад

Thank you :)

@reghuknair9488 2 года назад

Formula discription box ൽ ഇടുമോ

@unnikrishnanph1842 Год назад

I want s=1 number and letter code

@manissery1956 2 года назад

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 2 года назад

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

@jayeshlal1975 2 года назад

EXCELlent !

@XLnCADMalayalam 2 года назад

Many thanks!

@sulfikarIAS Год назад

Great classes ❤

@XLnCADMalayalam Год назад

Glad you think so 😀

@jafarabdu3398 Год назад

Great

@XLnCADMalayalam Год назад

😀

@sreejithsreelal2756 2 года назад

Thanks sir

@XLnCADMalayalam 2 года назад

My pleasure :)

@mohamadriyas4123 2 года назад

Super

@XLnCADMalayalam 2 года назад

😀Thank you

@riyazkm6460 2 года назад

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

@XLnCADMalayalam 2 года назад

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

@lorancemathew 2 года назад

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 2 года назад

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.

@suhail368 Год назад

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

@XLnCADMalayalam Год назад

Thank you for the suggestion :)

@ababu9862 2 года назад

Super super super

@XLnCADMalayalam 2 года назад

Thank you, Thank you, Thank you 😀

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