Excel Array Formulas Explained with MIN and IF Functions (Part 1 of 5)

Поделиться
HTML-код
  • Опубликовано: 16 дек 2024

Комментарии • 63

  • @juliecongress6278
    @juliecongress6278 5 лет назад +19

    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!

    • @erin3938
      @erin3938 4 года назад

      I agree. Your explanations are very user friendly and the pace is great. Thank you.

  • @peterbell3199
    @peterbell3199 6 лет назад +5

    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!

    • @ExcelCampus
      @ExcelCampus  6 лет назад +3

      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!

    • @mahindufrancis9998
      @mahindufrancis9998 6 лет назад +1

      That a reason to pray this useful guy to be around for a long time to come doing what he is doing.

  • @colinhodkin8680
    @colinhodkin8680 2 года назад +3

    Thank you for explaining this so well, I'm looking forward to seeing more of your videos

  • @johnq3543
    @johnq3543 4 года назад +3

    Thank you John, very helpful video as I begin to explore array's in excel

  • @shout-style
    @shout-style 6 месяцев назад

    Amazing Tutorial for array. Simple but powerful

  • @Amr-Ibrahim-AI
    @Amr-Ibrahim-AI 4 года назад +1

    Thanks a lot for simplifying this concept of Array formulas!

  • @krishgangs
    @krishgangs 4 года назад +1

    Brilliantly explained..clarified all my doubts on the basics

  • @hanneke2000
    @hanneke2000 10 месяцев назад

    Hallelujah, I finally get array formulas! Thank you Jon! ⭐

  • @IBITInformatica
    @IBITInformatica 2 года назад +1

    great explain... step by step interactions as it should be,,,

  • @varunchilveri9063
    @varunchilveri9063 3 месяца назад

    Great Explanation !!

  • @MrHugosky1
    @MrHugosky1 2 года назад +1

    I love your video and explanation! Thank you very much in deed!

  • @7XStriderX7
    @7XStriderX7 4 года назад +1

    Awesome lesson! Thank you!

  • @kebincui
    @kebincui 3 года назад +2

    Thanks Jon, very clear tutorial, easy to understand👍🏻👍🏻👍🏻

  • @fabianaltendorfer11
    @fabianaltendorfer11 2 года назад +1

    very helpful video!

  • @danielsossa1
    @danielsossa1 4 года назад +1

    Gracias Jon! Siempre encuentro soluciones contigo.

  • @grendbelema
    @grendbelema 2 года назад +1

    thanks for the explanation

  • @hamdanasr8574
    @hamdanasr8574 9 месяцев назад

    Great explanation.

    • @ExcelCampus
      @ExcelCampus  9 месяцев назад

      Glad you think so! 😀

  • @joem112
    @joem112 5 лет назад

    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.

  • @sowmyarajendran7863
    @sowmyarajendran7863 6 месяцев назад

    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)))

  • @CallMeGD
    @CallMeGD 10 месяцев назад +1

    Thank you very very much.

  • @صقر_الجزيرة
    @صقر_الجزيرة 3 года назад +1

    Great 👍

  • @entertainmentgalaxy971
    @entertainmentgalaxy971 6 лет назад +3

    great explanation.

  • @mukeshkimahfil4949
    @mukeshkimahfil4949 4 года назад +1

    Awesome, thank you so much sir!!

  • @vijaysahal4556
    @vijaysahal4556 3 года назад +1

    nice 👍🏻👍🏻👍🏻👍🏻

  • @gavinreeves7293
    @gavinreeves7293 4 года назад +1

    Thank you.

  • @ravishankargupta7233
    @ravishankargupta7233 5 лет назад +1

    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.

  • @ExceliAdam
    @ExceliAdam 6 лет назад +1

    Good translation of array formulas

  • @csIsKrass
    @csIsKrass 4 года назад +1

    Great!

  • @andrewphillips4381
    @andrewphillips4381 5 лет назад

    Excellent. I really appreciate the help.

  • @himanigoel897
    @himanigoel897 5 лет назад

    The concept has been explained very simply but I have a doubt will the formula work if there is blank rows in comparison column?

  • @karthikuppalapati2417
    @karthikuppalapati2417 4 года назад +1

    Thank you! :)

  • @bhupatparmar7728
    @bhupatparmar7728 6 лет назад

    Thanks, and was easy to understand. try to give 2 to 3 examples

  • @d.g.6203
    @d.g.6203 4 года назад

    Great video. However, couldn’t you use DMIN function with a AND statement to figure out the min with the specific criteria ?

  • @earljunreymalubay3204
    @earljunreymalubay3204 5 лет назад

    How about a formula that detects min value regardles if its green or blue??

  • @shivamdixit381
    @shivamdixit381 2 года назад

    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??

  • @taimoor4313
    @taimoor4313 2 года назад

    apply lint formula to extract Date from Text

  • @sharukhqureshi506
    @sharukhqureshi506 5 лет назад

    Fab Job Jon

  • @shvannajeeb2615
    @shvannajeeb2615 3 года назад +1

    Great

  • @klinikutamamediktama8084
    @klinikutamamediktama8084 4 года назад +1

    It's not working in my ms.excel 2013 version.. any suggestion??

  • @scotolivera8207
    @scotolivera8207 5 лет назад +1

    Thanks

  • @pardesipunjabi1493
    @pardesipunjabi1493 3 года назад

    Can this be done without array formulas nowadays?

  • @elouv
    @elouv 6 лет назад

    Hello, in the example of the MIN IF array formula you used ABSOLUTE references.Why is that? Any help will be appreciated!!

  • @emefatsatsu3883
    @emefatsatsu3883 6 лет назад +1

    i love it,

  • @pastorflat3864
    @pastorflat3864 6 лет назад

    awesome

  • @ralfsdiezins1161
    @ralfsdiezins1161 3 месяца назад

    CTRL SHIFT DINNER?

  • @rabiul910
    @rabiul910 3 года назад

    ? 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

  • @NiIndequi
    @NiIndequi 6 лет назад

    Good

  • @rajeshghai1494
    @rajeshghai1494 5 лет назад

    What is difference between array formula and simple formula

  • @lucaso3633
    @lucaso3633 3 года назад +1

    somehow most of the comment is from an employee

  • @robing6583
    @robing6583 6 лет назад +1

    Cool

  • @mahaboobhossain5076
    @mahaboobhossain5076 5 лет назад

    I NEED THIS PROJECT FILE BROTHER PLZZZZZZZZZZZZZZZZZZZZ

  • @paigehilliard6789
    @paigehilliard6789 6 лет назад

    what if you used the same formula but didn't make it an array?

  • @rocky16149
    @rocky16149 4 года назад

    bahut bak bak karta hai. video start after 2mins 6sec.

  • @shanejeftic688
    @shanejeftic688 5 лет назад

    GET TO THE FUCKING POINT

  • @basantjoshi491
    @basantjoshi491 3 года назад +1

    Thank you.

  • @logalakshminarayanan7382
    @logalakshminarayanan7382 2 года назад +1

    Great