Learning these new tricks of excel. Brain overload lol. How can this be done with the data on a separate sheet? I have a ton of data but wanted to know if and how that would work with the date on a separate sheet.
I created the drop down list , but when I clicked MAY , it does not connect to the right hand side number ,such as 5 . How to connect both drop down lists together ??
I want to asked, can i usk this function between 2 sheet which is enabled macro using form, on particular sheet1 have macro enable form data saved another sheet2 but I am pulling data from sheet 2 to sheet 1, but this function is not working plz help me
In my opinion, you can just added & between year and month to be specific, In critical array you can write year(array)=cell&month(array)=cell instead of just month(array)=cell.
Sir, kindly help. I need same thing with students record, if I type a name to search with a specific name I want this to all of the students with that name. Thanks
Here's an example. You can put this formula in any cell on any sheet, adjust the data ranges accordingly: =FILTER(VSTACK(Sheet1!A2:D4,Sheet2!A2:D4),VSTACK(MONTH(Sheet1!A2:A4),MONTH(Sheet2!A2:A4))=MONTH(Sheet3!A4&1),"No data found.")
if I have a list of client contacts made by several team members, how can I make a filter where I click on the name of the team member and see only their contacts?
Learning these new tricks of excel. Brain overload lol. How can this be done with the data on a separate sheet? I have a ton of data but wanted to know if and how that would work with the date on a separate sheet.
Thanks for this tips. Pls which video edition app do you use for your videos?
that can be very useful.
Waiting for next trick Excel, yuh are out of the box bro gud job👌
Craziest trick 🎉
🎈🎈🥳
What the Title name song ? Please tell me I love it . ❤❤
Podría usar tu material para crear shorts en español? Tienes algún curso al que pueda recurrir para llegar al nivel Max como tú?
First time I feel in the club learning Excel
Wonderful
Amazing 😮😮
Before this process, how to make month filter and number in next cell
Will make a tutorial for it.
I am interested in how to calculate km by postcode. That is, home code, work code and home code. So that it automatically calculates
super
I created the drop down list , but when I clicked MAY , it does not connect to the right hand side number ,such as 5 . How to connect both drop down lists together ??
I want to asked, can i usk this function between 2 sheet which is enabled macro using form, on particular sheet1 have macro enable form data saved another sheet2 but I am pulling data from sheet 2 to sheet 1, but this function is not working plz help me
Hi Sir your shorts are amazing master peice in excel thanks a lot I want to know the background music name?
Just use Shazam to get to know it.
@@GiuTor73 thanks sir but what's the full name I typed shazam but the background music is not that one what you have
What if the data has different years? Would the results be correct?
In my opinion, you can just added & between year and month to be specific,
In critical array you can write year(array)=cell&month(array)=cell instead of just month(array)=cell.
Sir, kindly help. I need same thing with students record, if I type a name to search with a specific name I want this to all of the students with that name. Thanks
not showing filter function in ms-2019 can u give alternative
Kindly help i am not able to convert the month from drop-down list to number
You guys classes are tough on me. I have being on this for 48hours now no solution. Because I am using Wps spreadsheet
Which software you record videos. How is possible formula bar is very large ??
Camtasia
@@LearnExceltoexcel How is possible Formula bar large ?
@@sagarindora72 You can increase the size of the font within the Formula Bar in Excel by changing the default text size to something larger.
Sir
Mere excel me filter formula nai dekharahi he ..
Ham keya kar sakte he ..sir 🙏
Full video link
Please Sir upload the next Tricks excel Shorts I'm waiting sir here, after long time please upload next new shorts ,what happened ??
They never uploaded new shorts anymore huh?
please help me with a formula, it has been bothering for about 3days
This formula not showing in excel. Kindly confirm Excel version.
how about if data are in different tabs or sheets
Here's an example. You can put this formula in any cell on any sheet, adjust the data ranges accordingly: =FILTER(VSTACK(Sheet1!A2:D4,Sheet2!A2:D4),VSTACK(MONTH(Sheet1!A2:A4),MONTH(Sheet2!A2:A4))=MONTH(Sheet3!A4&1),"No data found.")
How can I get the practice sheet
Available in description
if I have a list of client contacts made by several team members, how can I make a filter where I click on the name of the team member and see only their contacts?
Of you get the answer, share with me.
I don’t see the link
❤❤🎉
can you give me file excel practice this video
Sir mere system pr filter ka formula show ni ho rha h
sir this formula does not support in excel 2007 version
please say alternative formula for excel 2007
if not support this formula in crush version, how would I substitude for it sir
Power Query.
thank you sir
In the filter section, the amount shows 0
hi brother
link,please
Link to practice file is in the description
Type karne par filter ke jagha filterxml aajata hai
You need Excel 2019 or later to access FILTER function.
Use pivot table! Thank me later
McDiabetes😂😂😂😂😂