Two video that show a comprehensive list of solutions are: Excel Magic Trick 703: Extract Records Multiple Criteria (AND OR logic) Filter, Formula, Adv. Filter and Excel Magic Trick 758: Extract Data With Two Criteria - 5 Formula Methods
There is NO easy way. You have to use a complex array formula. I have many, many videos on this topic. I will have a video later in this class, but it will only show the very basics. I have many, many videos about this. My book Ctrl + Shift + Enter: Mastering Excel Array Formulas goes into great detail on this topic. Here is a playlist of videos here at UA-cam that has many examples on this topic: youtube [dot] com/playlist?list=PL63A7644FE57C97F4
Hello, Thank you for all your videos, they are outstanding! I had a quick question. I have a Pivot Table which I am trying to use an IF function in. However, it is grouped. For example, Yr 2010 Q1 Q2 Q3 Q4 Yr 2011 Q1 Q2 Q3 Q4 Yr 2011 Q1 Q2 Q3 Q4 I am trying to get my IF function to calcualte the total for Q4 only for 2010. I am using the IF by row ex, =IF(A1=B1, A1, 0) and at the end I would just add the total. But there are blanks under my years sections becuase it is a group. Plzz Help!
HI I have learned so much from you - thank you for taking the time to create these videos. Question, in your ex for approximate vlookup you only but the $ in front of the B but not 21 $B21? What is the rationale. Thank you
I am looking for a way to add data from sheet1 into sheet2 and then lock in that data on sheet2. This way, new data can be added into sheet1 and saved into sheet2. Any help would be greatly appreciated...
Two video that show a comprehensive list of solutions are:
Excel Magic Trick 703: Extract Records Multiple Criteria (AND OR logic) Filter, Formula, Adv. Filter
and
Excel Magic Trick 758: Extract Data With Two Criteria - 5 Formula Methods
I am sooooo addicted to your videos.... Once again excellent explanation.
Really Nice No need to take extra course out side .... your videos and work books are enough ,,thanks you made my day
There is NO easy way. You have to use a complex array formula. I have many, many videos on this topic. I will have a video later in this class, but it will only show the very basics. I have many, many videos about this. My book Ctrl + Shift + Enter: Mastering Excel Array Formulas goes into great detail on this topic. Here is a playlist of videos here at UA-cam that has many examples on this topic:
youtube [dot] com/playlist?list=PL63A7644FE57C97F4
You are welcome!
Note 2: the playlist also shows Filter and Advanced Filter methods if the situational demands do not warrant a formula.
I love your videos! They're informative yet entertaining. Can't appreciate them enough
Glad you like it!
The Slaying Excel Dragons series is the best summary at excelisfun:
youtube [dot] com/playlist?list=PL706DCCD130378289
Thank you for all your videos
Perfecto Excellento Bravo Ma boi
Amazing! I think you make the study so funny! Love!!!
Glad you love it!
ExcelIsFun Wow you keep watching UA-cam?
Great tutorial you'r the king. ♛
Thank you very much for this in 2020 and I still find this relevant. Now my question is why did you not lock the formula when you did the Vlookup
Great Video! Thanks for the explanation!
Hello, Thank you for all your videos, they are outstanding!
I had a quick question.
I have a Pivot Table which I am trying to use an IF function in. However, it is grouped.
For example,
Yr 2010
Q1
Q2
Q3
Q4
Yr 2011
Q1
Q2
Q3
Q4
Yr 2011
Q1
Q2
Q3
Q4
I am trying to get my IF function to calcualte the total for Q4 only for 2010.
I am using the IF by row
ex, =IF(A1=B1, A1, 0) and at the end I would just add the total. But there are blanks under my years sections becuase it is a group.
Plzz Help!
glad, i found you,
Sir what to use if the look value in the table array is repeated many times? Thank you in advance
Superb! Thank you so much!
HI I have learned so much from you - thank you for taking the time to create these videos. Question, in your ex for approximate vlookup you only but the $ in front of the B but not 21 $B21? What is the rationale. Thank you
Can VLookup search between two columns and give me a result? Meaning if column a = 1 AND column b = 2 then I get...
I am looking for a way to add data from sheet1 into sheet2 and then lock in that data on sheet2. This way, new data can be added into sheet1 and saved into sheet2. Any help would be greatly appreciated...
you are genius
Not really, I am just a guy having fun with excel!!! :)
Nice, You are cool!!
Try:
mrexcel [dot] com/forum
Maybe with VBA code. Try:
mrexcel [dot] com/forum
nice arts
Glad you like it!
yo