This is the most intuitive tutorial ever for filter by using actual formula. Especially useful for people like me using older excel versions. Really appreciate your great effort in making these videos.
@excelisfun
12 жыл бұрын
I am glad that you liked it!
@excelisfun
12 жыл бұрын
I am glad that you like it!
@CassAnayadotcom
7 жыл бұрын
You have no idea how IMMENSELY this helped me! Thank you!
@excelisfun
7 жыл бұрын
Glad it helps! Thanks for the Sub and Thumbs Up : )
@excelisfun
12 жыл бұрын
I am glad that you like it!!
@excelisfun
12 жыл бұрын
You are welcome for the color and information!
@rda51
12 жыл бұрын
Another great lesson from the world's best excel teacher. Thanks again, Mike!!
@excelisfun
12 жыл бұрын
You are welcome! Since I am not good with VBA, I do not post VBA videos. :(
@eelabob
7 жыл бұрын
wow spend hours trying to accomplish this by myself before google brought me here , thanks your a star
@excelisfun
12 жыл бұрын
You are welcome!
@excelisfun
12 жыл бұрын
Thanks, Hamy72. It was a wowie kazowie because there was so much stuff in it!
@excelisfun
12 жыл бұрын
Cool! I am glad that you like it!
@PacoSaez
12 жыл бұрын
Great explanation. Congratulations from Spain (Almería)
@excelisfun
11 жыл бұрын
I am not sure. Try THE best Excel question site: mrexcel [dot] com/forum
@excelisfun
12 жыл бұрын
starragav, I am glad that you like the videos!! My Excel name is: excelisfun!!! You got it right!
@kwokkerdekwok
9 жыл бұрын
This was such a handy tutorial! It helped me a lot. Thanks a lot!
@1234saiwa
12 жыл бұрын
This one is GREAT! so many interesting tricks, though it takes me to watch twice to digest :)
@ardeshiraqayi9976
3 жыл бұрын
WOW... too old BUT too informative ...!!
@excelisfun
3 жыл бұрын
Glad the oldie helps : )
@derekl175
11 жыл бұрын
excellent, you are the Super Hero of Excel
@MM-lu3zp
5 жыл бұрын
Is it possible to filter an array using multiple drop down lists. So if I were to use your example: Type, Model, Color, Price, instead of just using a dropdown list to filter Type and Model, I would also like to filter by Color and Price. Also, I would like to filter the results possibly not in that particular order, maybe just look up Model and Color and it will filter the Types and Models. I would still like to have all the filtered information in the same table, which I am sure would require an extremely long helper formula. I am currently using Excel version 2003.
@albertgutierrez7798
6 жыл бұрын
This tutorial helped me a lot... thank you!! your doing the world a great service by sharing your knowledge!! :-)
@starragav
12 жыл бұрын
Hi ExcelisFun, I dont know your name. But I want to know your name. I recently subscribed to your channel. All the videos posted by you is awesome and intelligent. In addition to that special thanks for this video. You are a genious. I am a great fan of you. Well done!!
@sandoognair
10 жыл бұрын
This is awesome...the exact stuff I was looking for..thanks a lot
@excelisfun
10 жыл бұрын
glad you like it!
@snowman1987
4 жыл бұрын
Is there a video, or way to have an invoice only populate items from a larger list who's order column/ value is greater than 0 without empty rows??
@RahulJauhari
6 жыл бұрын
Sir you are master of excel great trick
@NitinGRathod
10 жыл бұрын
that is awesome dude. I was having hard time to do it. you rock....
@excelisfun
10 жыл бұрын
Glad you liked it!
@bighomie2909
7 жыл бұрын
Thx for all of ur videos. I find ur channel amazing. In regards to this tut, i can't figure out how the helper column and the no column are collaborating... In other words, how that the index function returns the right answer considering that both Toyota and Chevy are marked with no 2? thx
@pbyrne462
10 жыл бұрын
Having a problem getting the right formula in the helper column to fit my needs. The user can choose either criteria indvidually, so if I change the formula to an OR this will return what I need. But I also need to narrow the filter to an exact match if both criteria are filled. Currently as it should the OR function returns any records containing the criteria entered and I need it to recognise that both are complete so narrow this to only records that fit exactly. Hope I have explained correctly.
@hindsgroupsalesmarketing9808
10 жыл бұрын
Thanks so much for the helpful video. Is there a way that you can make the results auto sort by price low to high?
@headoffice1715
10 жыл бұрын
This is immense and beyond helpful. Thank you very much. One question. Can this be adapted to work when only one of the two criteria are selected? I am trying to generate stats based on Geographical Region & Calendar Quarter. So the demonstration above is brilliant when I want the stats for quarter 1, region 2. But If I ask it for just the region, then I get nothing. Same goes is I want all records from 1 quarter.
@1994ramfan
6 жыл бұрын
You're a GOD! Thank you so MUCH!
@xReTrO89x
5 жыл бұрын
true legend, just did my project thx to this
@excelisfun
5 жыл бұрын
Glad this vid helped with your project! Thanks for your support : )
@amitdesai1859
4 жыл бұрын
Hi, nice video. but can you help me with my requirement? in ref. to your video i want to have only unique value . i.e. if i select only Toyota i want to filter only unique value of its model in your case Camry came two times but i want it to appear only one time with other models (without selecting its model separately). is it possible? Thanks in advance.
@hsid42
4 жыл бұрын
GREAT SIR
@camelnaction
8 жыл бұрын
Hi Excelisfun. That was a great way to extract information. Thank you for the Video.Is there a way to have the same results extracted or even counted but without the Helper Column? Reason being, in my excel sheet I am importing a large amount of information and do not use VBA to include an automatic helper column. So therefore I cannot use a Helper column. Possibly using the SUMPRODUCT formula. Any Thoughts? Thanks a lot again!!
@MajorAuditor
12 жыл бұрын
great I Really Like The Lesson
@13karatemaster
12 жыл бұрын
wow, my head jut exploded but amazing tutorial, thanks!! :D
@janabaker4219
11 жыл бұрын
Yes, all your videos are great. I've learned so much. However, i'm having a hard time with something. I need to be able to use Combo Boxes (ActiveX) for a dashboard i am building. The combo boxes would need to behave like data validation though...meaning the user would select Portfolio, then the Director, then manager, then month....all would cascade...aka only bring back the Dir under Portfolio A, the Mgr under that Dir, etc. Can you HELP me pretty please. Nothing is working.
@ashmil8888
11 жыл бұрын
Great stuff! one question from me, how if I have to use wildcard instead of exact name to match the items in the list? how's the formula like? Thanks in advance.
@MohdSaifoulAzuan
5 жыл бұрын
Thank for the video, 1 hope you can update its with new formula. tq
@suprcatalis
7 жыл бұрын
So i tried this on a data set and all the formulas work fine on the first worksheet but when i tried to copy the current worksheet to a new one ( Even though the formulas copied they wont work at all) any ideas?
@troooy88
11 жыл бұрын
Hello! Great video! this is very useful! I have a question though, is there a way where I have 3 or more criteria and it adjusts they way AutoFilter behaves? it filters out items not under the first criteria, and the other criteria adjust the choices to those left? :)
@wyannreport1810
7 жыл бұрын
tks for sharing this, love it
@tomcalandriello1482
7 жыл бұрын
I want people to be able to add comments to the table created, not the source table, but when you change the filtered criteria their comments stay in the cell it was typed in and doesn't stay with the specific line they had made the comment for. Any tips on how to make this table interactive?
@hsid42
4 жыл бұрын
thank u sir
@carlosdelgado9084
6 жыл бұрын
Trying to use this with Google Sheets, Can't seem to get helper formula to work.. any ideas?
@emilytumy
6 жыл бұрын
THANKS THIS IS AWESOME
@mahmoudsherif5103
9 жыл бұрын
when i do the step of "=indirect( ) " it show an error message says: the source currently evaluates to an error !!!!! please tell me what can i do it's excel 2010
@chrisbenton5966
7 жыл бұрын
I'm having the same issue, but I'm guessing you didn't get an answer to your question, since I see no reply. . . Did you have any luck elsewhere?
@lloydbooker6084
6 жыл бұрын
Ensure the first dropdown list has data (Toyota) selected then select the cell for the second dropdown list and follow the instructions as shown in the video.
@chrisbenton5966
7 жыл бұрын
I am having trouble w/ the indirect function. I used the dynamic range formula provided in EMT916 to exclude blanks in a Named Range so that when new records are provided in the blanks that it would automatically update the named range. The trouble I'm have is that it will not let me use the indirect function to get that dependant drop down list into the adjoining cell. Are you aware of any fixes for this issue? It was a very cumbersome & tedious process to establish all of these dynamic ranges & these feature would be overwhelmingly beneficial to every day tasks I am to perform. Any insight as to what could be the cause of this problem? I am getting an error that states "the Source currently evaluates to an error. Do you want to continue?". . . Not sure if that will help. Please help, I feel like I'm so close! Thanks for your consideration.
@chrisbenton5966
7 жыл бұрын
+ExcelIsFun
@amaurycdiaz
11 жыл бұрын
Just amazing!!!!
@igamaliel
12 жыл бұрын
you rock man. thanks
@Thesaddamsaifi
7 жыл бұрын
good
@mohdfauzymohdyusof68
8 жыл бұрын
nice...
@mobinnaim786
12 жыл бұрын
its great
@timwebster4549
10 жыл бұрын
Does the indirect function in the Data Validation only work in versions later than 2003? I cannot get it to work.
@excelisfun
10 жыл бұрын
For tables? yes.
@timwebster4549
10 жыл бұрын
ExcelIsFun
@lidyannvanderwolf7989
8 жыл бұрын
ɷɷɷ Heeyy Friendsss I Have Founddd Workinggg Online Hacck visittttt : - t.co/vOFsUFqOI7
Пікірлер: 71