I'm Such a huge a fan of this channel. No voiceover, just straight demo. Love it ❤ Whenever I scroll TH-cam shorts, I come across this channel then learn something new 😊
And what if you want to use the data in formula??? Will pivot table help? Pivot table has its place where we need to summarize the data. If we need to process a filtered data, FILTER function is one of the best thing happened to Excel. Sending another tutorial with FILTER function in few minutes your way!
Is this possible to search for required sheet name when there are large number of sheets in a workbook if possible please make a video on that through your channel
As per support documents. 2019 onwards version support FILTER function. But Excel for web and Android/iOS apps have this formula. And you can use these facilities for free.
Can't spill multiple matching values. Way too complex to get the job done. FILTER function is a lot easier to use and less prone to breaking. If one dont want to use filter function. Power query is the second best option
One not having version of Excel in which we don't have this filter function...then we can make use of INDEX AND AGGREGATE FUNCTIONS or INDEX WITH HELPER COLUMNS
Is this possible to do this if the information is in one cell? Like if Benedict Customer Care was in one cell could I create a filter to split the info into two columns? Lol I have a few hundred names I have to manually separate and I am not Microsoft proficient in any way😅
I legit try to create filters... but more with dynamic tables. This one seems legit fun to learn. Do you have a longer version for multiple columns attached to 1 category?
I think you are asking Excel version. The one I have is Excel 365, but you can use FILTER function in 2019 version onwards and also on Excel for web and Android/iOS Excel apps.
VLOOKUP, XLOOKUP, FILTER, INDEX/MATCH so many ways to do it. You can also use FILTER feature in excel. Also conditional formatting can be used to highlight such invoice number in data.
Access or Download Practice workbook for this Excel tutorial: 1drv.ms/x/s!Apno7889bCyLj1EYvIsJh92wI36F?e=7j096d
@prernasingh5055do it manually
@prernasingh5055 if ur keyboard is having Fn key then try while holding it
@prernasingh5055
Click Fn + F4
im still trying to figure out the yellow and green bar, i was doing it by myself in Book1 - Excel . my Tab is set at "Insert
Ctrl+shift+down arrow while selecting range is a useful shortcut :)
Yes!!!! Hi5!!!! And to get back to first cell of the range hit CTRL+BACKSPACE 🤯
@@LearnExceltoexcel thanks! New learning!!
Ctrl+a is best for whole selection.
@@LearnExceltoexcelhey you are teaching all my hidden tricks 😢
Thanks you.
Best part of this tip is the lock range shortcut! I've been looking for it for years, but didn't know the right name for it. Thanks!
Wow :) Glad you unlocked something special today. It is indeed one of the tiniest bit in Excel that is of great use. Happy Excelling!
Can put u file
F4 is the short cut
For years? Jeez man
😂 me too... always put the $'s in manually
This channel is a life saver, cause learing from shorts is much easier than long videos!!!
it just poped up on my tiktok vids..
this is my very first time subscribing on tiktok videos...worth it..thanks..
Bucket load of encouragement just when it's needed :) hi5!!!
I'm Such a huge a fan of this channel. No voiceover, just straight demo. Love it ❤ Whenever I scroll TH-cam shorts, I come across this channel then learn something new 😊
Wonderful 👍, it works really and save many minutes. Thanks for Sharing 🙏
Thank you so badly needed this for data cleanup. Pivot table gave me things I dont need. 😵💫
Why don’t you use pivot/unpivot columns in power query?
Your video is awesome and easy steps
Glad you liked it
Great job 👏
Could be done with Vlockup as well, right?
Brilliant ❤
Thanks!
Best solution for that is pivot table and also it helps you to enhance the file size of your file
And what if you want to use the data in formula??? Will pivot table help?
Pivot table has its place where we need to summarize the data.
If we need to process a filtered data, FILTER function is one of the best thing happened to Excel.
Sending another tutorial with FILTER function in few minutes your way!
Nice!
Bhai, your explanations are truly worthy..
bhai can you please suggest me clients ko rapidly kaise trap krein?
Nice little trick
Very useful. Thank you 🙏
Glad it helped
Thanks Sir/Ma'am Like it Very Much.
Your Simplicity of Explanation🙋♂️
Glad it helped.
Best video 👍
Thanks
@@LearnExceltoexcel welcome
Great video
Glad you enjoyed it
Finally, a nice somewhat cross pivot text function . Thanks for sharing
Yes! I still believe this function should have been given more 'powers' but still what we have is no small thing!
Excellent job!! Btw, did you make this video from phone or pc screen? Thanks
love your skills ...
🎉🎉
Superb
Thanks 🤗
Nice one
Very good
এরক ভিডিও ভালো লাগে ভাই, সহজে শিখতে পারি
Just brilliant
🥳🥳🥳🥳
Advanced Filter is also useful!
Wow... Filter works better...
Weldone...keep it up
One of my favorite function recently
Wow, superb trick!
I really like your video and I would like to know how the two animations that are incorrect and correct are made in the video ✅❌
❤This is great Sir ❤❤
Thank you a lot. I was using IFS command for 400 row list so I had to add each specific row from the list into script.
😳😳😳😳😳😳😳😳
What monstrosity were you upto 🥺
❤️ you brother
🤩🤩🤩
Super 🎉
Thanks
Best 👌
🙏 thanks
Keep it up
Thank you and stay blessed
Thank you
Pleasure! 😊
Good
Amazing
Super dear 💕
♥️♥️♥️
Filter function works only in MS Excel 365
It also works on Google sheets
Yes I tried it in old version and got error.
Nice
Great song 🎉
THANKS
🎉
Is this possible to search for required sheet name when there are large number of sheets in a workbook if possible please make a video on that through your channel
Sir mujhe basic aur advance Excel sikhana hai per day 1 hour study Karun to kitne manth lagega
In my case there is no filter function now what to do any suggestions please?
We can also filter by criteria.
Where i can download this practice sheet ?
Genial🎉
Why do we lock the Range?
I love the song 😂😂😂😂😂😂
And add any function in Excel then harmful security show this msg. how to add any function?
filter function doesn't work in 2019, suggest any another way to use this function
Wondering if you can do that in reverse? Meaning from several dept column into name and dept column only.?
Means you want to get the department name for each employee?
@@LearnExceltoexcel ya, just like the columns F and G on the right.
Can we do it by v lookup
No i guess cells having similar values will pop error in vlookup or xlookup
How can I save this video? Haha. Does it only run for exact array? or maybe (example : there is contain "Finance") we can get all kind of finance?
There should be a way to download shorts in TH-cam app.
We can have multiple columns output. Tomorrow's video will be about it :)
Or if you have a different idea then let me know and will try to incorporate it in my example
So which is better? =filter or =vlookup function?
In which version of Excel we can use filter function, as i tried it in my system it suggested filterxml only
As per support documents. 2019 onwards version support FILTER function. But Excel for web and Android/iOS apps have this formula. And you can use these facilities for free.
Same here
Which song is this please give a link .
Ikson remix named runaway
Wts that background music? Explain it or leave with a simple ringtone
Not a vlookup? interesting! Thanks
FILTER is basically a lookup function. So you can say that it is a special kind of VLOOKUP
nice
What about Index and MATCH function
Can't spill multiple matching values. Way too complex to get the job done. FILTER function is a lot easier to use and less prone to breaking. If one dont want to use filter function. Power query is the second best option
How to seperate letters and digits one colum to another
We can use pivot right
You can. But to many steps for such a simple work. Power Query will be a better alternative
I don't have this filter formula in ky excel so what to do?
Power Query is the next best alternative
Apakah ini berhasil di WPS ?
One not having version of Excel in which we don't have this filter function...then we can make use of INDEX AND AGGREGATE FUNCTIONS or INDEX WITH HELPER COLUMNS
I will suggest to use Power Query. Much more flexible and powerful. Much easier to use as well.
Kanye being in HR literally gave a spike in anxiety. 😅
😆😆😆
Arnold doing IT is no small thing either 😂
Super
😇😇😇
Is this possible to do this if the information is in one cell? Like if Benedict Customer Care was in one cell could I create a filter to split the info into two columns? Lol I have a few hundred names I have to manually separate and I am not Microsoft proficient in any way😅
Are they separated by comma or space?
Whats the formula for 2016 or below version?
In such cases power query is a better option otherwise a complex lookup formula is needed.
I legit try to create filters... but more with dynamic tables. This one seems legit fun to learn. Do you have a longer version for multiple columns attached to 1 category?
You want to fetch values from multiple columns or get multiple columns against filter applied to one column? 🤔
@@LearnExceltoexcel 0
I am thinking about the filter formula...now I got it...
Aurora - Runaway, but which remix?
Musica Electronica. You're welcome
कौन सा 𝘃𝗲𝗿𝘀𝗶𝗼𝗻 𝗵𝗮𝗶?
I think you are asking Excel version. The one I have is Excel 365, but you can use FILTER function in 2019 version onwards and also on Excel for web and Android/iOS Excel apps.
how could it automatically be filled for the down cells? thanks.
No need... This is an array formula and will spill automatically for you to get all the results
@@LearnExceltoexcel appreciate it.
i think you can just use filter tool like drop down in Department
Please try to provide attachment of the problem it would be easier to practice
Providing fir the latest ones. But will try to pull this one as well and make it available
I can't use this i am using excel 2010. Please show how to use it in 2010 or lower versions
i don't have filter function what function may be work?
If filter function is not available then the next best thing is power query
@@LearnExceltoexcel can you make video on it?
One suggestion please keep the music or song at extremely low volume so can concentrate on the learning
this can be done with sort option
That will be all manual labour... Sure that is one way... But we have better ways now ☺️
If my Excel doeesn't have Filter formula. What must I do sir
Power Query is the next best thing.
How to join this job
Thx
Sir auto printing ka code dijiye pls invoice jeise save karenge sath sath
you want to generate invoices? Let me know the use case and I will try to help at my best!
@@LearnExceltoexcel I have invoice, auto save and auto print by one click the shape button
Why not just sort the table by detartment, then alphabetically by team. Then copy and paste the lists of names over?
I know, bro. If one can realize the uses of sorting, it will make his life and work easier
This filter option is not shown on my pc when I try to do it
What about when I add data to F & G? Does it update dynamically?
Having the source data range in the form of a table will make the solution completely dynamic and it will update it entries or changes are made.
Filter Function Exist which Version ?? I use excel 2016 and its dont appear fillter function
Whenever I press f4 some other setting open cell does not lock I am laptop user please tell what I have to do for locking the cell instantly
Your laptop probably requires pressing "Fn" key as well for function keys to work.
Excel mei old invoice keise find karta hai invoice number se
VLOOKUP, XLOOKUP, FILTER, INDEX/MATCH so many ways to do it. You can also use FILTER feature in excel. Also conditional formatting can be used to highlight such invoice number in data.