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 🙏
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.
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???
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?
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
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.
PALA ROW CALILAYI DATE KODUTHITTUNDE LIKE N1 : 100 , AC2:1000 , ETC , SAME WORK FILE IL VERE SHEETIL DATE WISE (TODAY) FULL SHEET DATA KANIKKAN PATTUMO? WITH DROPDOWN BUTTON
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.
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.
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.
ഒരു row select ചെയ്യുകയാണ് . 500 lines und. അതിൽ some columns formula ഉള്ളത് ഉണ്ട് ഇല്ലാത്തതും ഉണ്ട് . എങ്ങനെ നമ്മൾക്കു formula ഉള്ളത് highlight ചെയ്ത് കാണിക്കാൻ ഒക്കും .. please advise Thanks
ഈ ഫോർമുല ലഭ്യമായിട്ടുള്ള വേർഷനിൽ നിന്നും ഈ ഫോർമുല ലഭ്യമായിട്ടില്ലാത്ത വേർഷനുപയോഗിക്കുന്ന ഒരാൾക്ക് ഫയൽ അയച്ചു കൊടുത്താൽ എന്ത് സംഭവിക്കും? ഫോർമുല റിസൾട്ട് ഫയൽ കിട്ടിയ ആൾക്ക് കാണാൻ പറ്റുമോ?
Love it. I'm already started using the filter formula. Thank you!
You're so welcome!
Thank you, your are very professional
😀👍
10:33 ... Without closing brackets how it works ??
Try it yourself👍
Wonderful and must know function. Thanks for sharing..
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 🙏
Thank you for your kind words :)
Who is the perfect trainer...voice clarity no words...
Please check 16:31, here you intended to get all senior managers from the table, but it shows other designations also. Why?
Watch from 14:42. Here we are filtering data with an OR condition. Either 'Technical Department' or 'Senior Manager' position.
Excellent teachings thank you
Glad to hear that 😀
Very powerful function. വളരെ വ്യക്തമായും കൃത്യമായും വിഷയം അവതരിപ്പിച്ചു തന്നതിന് നന്ദി.
My pleasure :)
Excellent class.. Thanks for sharing...
😀 You are welcome!
You are the best,
👍 Very Good Explanation
Thank you :)
Today i have tried this.Very helpful.Thank you so much😍
My pleasure :)
Your way of explanation is awesome.
Loved it.
Your videos have been part of my life.
Thank you
Glad to hear that😀
Very precise and clear narration 🙏🙏👍🏽👍🏽👍🏽
Thank you :)
Your video is very useful for both excel beginers and expertize.Keep it up
Glad to hear that. Thank you :)
Thanks for our effort to teach excel
My pleasure :)
Well explained
Thank you :)
Very good
Ee function Vere level 💥💥💥
Yes 😀
Thanks, it was a good presentation.
Glad you enjoyed it!
സൂപ്പർ.....
Thank you :)
Excellent 👍
Thank you :)
Powerful thank you sir
My pleasure :)
Thanks...........
You're welcome!😀
Great as usual!
Thank you :)
Powerful information 👌
Glad you think so!
Great classes ❤
Glad you think so 😀
Very interesting. Thank you very much. (Sadik- Doha Qatar)
My pleasure :)
👏👏👍🙏🙏
Hi sir I learn Excel by watching your video
Glad to hear that Nahil :)
Great
😀
Good
😀👍
Very Useful!
Glad you think so!
Hi ,can you please share a video of power apps ?
Thank you for the suggestion :)
EXCELlent !
Many thanks!
Chetante class adipopoli
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.
Thank you for the suggestions :)
Super
😀Thank you
Super super super
Thank you, Thank you, Thank you 😀
Thanks sir
My pleasure :)
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???
I can't figure out why that is happening. Make sure that the calculation mode in Excel is set to Automatic.
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?
How using excel for web
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.
Unique and filter new version kittunilla
Filter fuction first google sheet il undarunn
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?
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
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.
How can it be so powerful when we can simply use drop down filter?
PALA ROW CALILAYI DATE KODUTHITTUNDE LIKE N1 : 100 , AC2:1000 , ETC , SAME WORK FILE IL VERE SHEETIL DATE WISE (TODAY) FULL SHEET DATA KANIKKAN PATTUMO? WITH DROPDOWN BUTTON
Excel sheetil Small letter aayi typ cheytha words enganeyan Capital letter akkan pattumnath ?
Please refer my videos on UPPER, LOWER and PROPER functions in Excel.
adipolii , but function lla old version aahn
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.
ഈ ഫിൽട്ടറിംഗ് വേറ മെത്തേടിൽ ചെയ്യാൻ പറ്റുമോ ms ഓഫീസ് 2016 ൽ വർക്ക് ചെയ്യുന്ന മെത്തേട് ഉണ്ടോ ഒരു വീടിയോ ചൈതാൽ വളരെ നന്നായിരുന്നു.
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.
I want s=1 number and letter code
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.
ഫിൽറ്റർ function ഇല്ലാതെ ഒരു search box create ചെയ്ത് ഫോർമുല ഉപയോഗിച്ച് data ഇതുപോലെ filter ചെയ്ത് എടുക്കുവാൻ കഴിയുമോ
ഒരു row select ചെയ്യുകയാണ് . 500 lines und. അതിൽ some columns formula ഉള്ളത് ഉണ്ട് ഇല്ലാത്തതും ഉണ്ട് . എങ്ങനെ നമ്മൾക്കു formula ഉള്ളത് highlight ചെയ്ത് കാണിക്കാൻ ഒക്കും .. please advise
Thanks
Formula discription box ൽ ഇടുമോ
വളരെ പ്രയോജനമുള്ളത്.... Pivot table, vlookup ഇവ ഇതു പോലെയല്ലേ?
I am curious. What makes you think that PivotTable, VLOOKUP and FILTER function are same.
Sir പുതിയ എക്സലിൽ ഫിൽറ്റർ ഫോർമുല കിട്ടുന്നില്ല...
Please watch the last portion of the video to know about the versions of Excel that have FILTER function.
ഈ ഫോർമുല ലഭ്യമായിട്ടുള്ള വേർഷനിൽ നിന്നും ഈ ഫോർമുല ലഭ്യമായിട്ടില്ലാത്ത വേർഷനുപയോഗിക്കുന്ന ഒരാൾക്ക് ഫയൽ അയച്ചു കൊടുത്താൽ എന്ത് സംഭവിക്കും? ഫോർമുല റിസൾട്ട് ഫയൽ കിട്ടിയ ആൾക്ക് കാണാൻ പറ്റുമോ?
👍👍👍👍
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 ചെയ്യുന്നതെന്ന് പറയാമോ
Enikk ee function kitunila
Please watch the last portion of the video to know about the versions of Excel that have FILTER function.
❤
😀👍
excel ഇൽ ഫിൽട്ടർ കിട്ടുന്നില്ല
ഫിൽറ്റർ ഫങ്ഷൻ ഇല്ല
⭐⭐⭐⭐⭐
❤