The explanations are incredibly user friendly, the speed perfect, and the examples spot on. I plan on viewing all videos from excel campus. 10 out of 10 recommend!
How does this channel not have like 10 millions subs? I watch them at work, because they help me become a better and more productive employee, with the Excel knowledge I gain!
One little bit of feedback you may also press the Enter button (in lieu of the space bar) to advance the Evaluate window to the next step. But I like the spacebar because it is easier to hit.
Thank you for the detailed explanation and examples! It's very helpful. I'd like to apply this to a specific scenario. I need a formula that can find the month(s) with the highest amount spent across different months. It should also account for situations where multiple months have the same highest spending amount. Could you please help me with a formula for this case? I tried this formula, but it throws a formula parse error: =ArrayFormula(QUERY(C21:D32,MONTH(B21:B32)=max(VALUE(D21:D32))group by MONTH(C21:C32)))
Nice video! I want to learn about all functions related to array, so can you please make a video or provide me like of the videos by which i could learn the same.
I need one help. I have one sheet in which data comes from another sheet. In this new sheet there are some data blank in 1 row (suppose row 'X"). I want only filled data from that "X" row with all other rows & column to another sheet automatically. How can it be done??
? Question : The formula =MAX(($D$2:$D$12)*($C$2:$C$12=C2)) can find out the maximum value of the range but why the formula =MIN(($D$2:$D$12)*($C$2:$C$12=C2)) can't find the * minimum* value
The explanations are incredibly user friendly, the speed perfect, and the examples spot on. I plan on viewing all videos from excel campus. 10 out of 10 recommend!
I agree. Your explanations are very user friendly and the pace is great. Thank you.
How does this channel not have like 10 millions subs? I watch them at work, because they help me become a better and more productive employee, with the Excel knowledge I gain!
Thanks so much Peter! :-) 100k subs is the next goal, but 10 million would be great! haha! I really appreciate your support. Have a nice weekend!
That a reason to pray this useful guy to be around for a long time to come doing what he is doing.
Thank you for explaining this so well, I'm looking forward to seeing more of your videos
Thank you John, very helpful video as I begin to explore array's in excel
Amazing Tutorial for array. Simple but powerful
Thanks a lot for simplifying this concept of Array formulas!
Brilliantly explained..clarified all my doubts on the basics
Hallelujah, I finally get array formulas! Thank you Jon! ⭐
You're welcome! 😀
great explain... step by step interactions as it should be,,,
Great Explanation !!
I love your video and explanation! Thank you very much in deed!
Awesome lesson! Thank you!
Thanks Jon, very clear tutorial, easy to understand👍🏻👍🏻👍🏻
very helpful video!
Gracias Jon! Siempre encuentro soluciones contigo.
thanks for the explanation
Great explanation.
Glad you think so! 😀
One little bit of feedback you may also press the Enter button (in lieu of the space bar) to advance the Evaluate window to the next step. But I like the spacebar because it is easier to hit.
Thank you for the detailed explanation and examples! It's very helpful.
I'd like to apply this to a specific scenario. I need a formula that can find the month(s) with the highest amount spent across different months. It should also account for situations where multiple months have the same highest spending amount.
Could you please help me with a formula for this case?
I tried this formula, but it throws a formula parse error: =ArrayFormula(QUERY(C21:D32,MONTH(B21:B32)=max(VALUE(D21:D32))group by MONTH(C21:C32)))
Thank you very very much.
Great 👍
great explanation.
Awesome, thank you so much sir!!
nice 👍🏻👍🏻👍🏻👍🏻
Thank you.
Nice video! I want to learn about all functions related to array, so can you please make a video or provide me like of the videos by which i could learn the same.
Good translation of array formulas
Great!
Excellent. I really appreciate the help.
The concept has been explained very simply but I have a doubt will the formula work if there is blank rows in comparison column?
Thank you! :)
Thanks, and was easy to understand. try to give 2 to 3 examples
Great video. However, couldn’t you use DMIN function with a AND statement to figure out the min with the specific criteria ?
How about a formula that detects min value regardles if its green or blue??
I need one help. I have one sheet in which data comes from another sheet. In this new sheet there are some data blank in 1 row (suppose row 'X"). I want only filled data from that "X" row with all other rows & column to another sheet automatically. How can it be done??
apply lint formula to extract Date from Text
Fab Job Jon
Great
It's not working in my ms.excel 2013 version.. any suggestion??
Thanks
Can this be done without array formulas nowadays?
Hello, in the example of the MIN IF array formula you used ABSOLUTE references.Why is that? Any help will be appreciated!!
i love it,
Thanks Emefa! :-)
awesome
CTRL SHIFT DINNER?
? Question : The formula =MAX(($D$2:$D$12)*($C$2:$C$12=C2)) can find out the maximum value of the range but why the formula =MIN(($D$2:$D$12)*($C$2:$C$12=C2)) can't find the * minimum* value
Good
What is difference between array formula and simple formula
somehow most of the comment is from an employee
Cool
Thanks May! :-)
I NEED THIS PROJECT FILE BROTHER PLZZZZZZZZZZZZZZZZZZZZ
what if you used the same formula but didn't make it an array?
bahut bak bak karta hai. video start after 2mins 6sec.
GET TO THE FUCKING POINT
Thank you.
Great