CHECKBOXES-FILTER+XLOOKUP MAGIC

แชร์
ฝัง
  • เผยแพร่เมื่อ 2 ธ.ค. 2024

ความคิดเห็น • 31

  • @moshoodjamiu5828
    @moshoodjamiu5828 ปีที่แล้ว +3

    THIS GUY DON TEACH ME MORE THAN MY LECTURER SELF... GOD BLESS U

    • @ExcelMoments
      @ExcelMoments  ปีที่แล้ว

      Hahahahaha, your lecturer doesn't teach Excel, does he? 😀 appreciate your kind words

  • @jazzista1967
    @jazzista1967 ปีที่แล้ว +1

    HI Victor.... Finally, i got to watch your new video just in time for this feature to rolled into my 365 account over the weekend. I have been waiting for this feature almost 3 weeks to appear. I just used it inside the filter function with TRUEs AND FALSEs on the columns I want to display on a table and works like a charm. You showed this trick on the FILTER function demonstration on the Toronto excel group a few months ago. Again man, thanks for posting such great cases!

  • @IvanCortinas_ES
    @IvanCortinas_ES ปีที่แล้ว

    Certainly with CheckBox there is a new world of possibilities that improves the appearance, analysis and presentation of data. Thank you Victor.

    • @ExcelMoments
      @ExcelMoments  ปีที่แล้ว

      Absolutely. Ivan Thank you for your feedback and Yes, you are welcome

  • @KevinPGA
    @KevinPGA ปีที่แล้ว +1

    Beautiful. I enjoy the way you go through each step using simple logic then put it all together... Thank You!

    • @ExcelMoments
      @ExcelMoments  ปีที่แล้ว +1

      Thanks for the feedback. Anything to help the audience understand

  • @qasimawan3568
    @qasimawan3568 ปีที่แล้ว +1

    Elegant and simple solution. I love it when you talk through your thought process for solving problems. Keep it up :)

    • @ExcelMoments
      @ExcelMoments  ปีที่แล้ว

      Thanks for the feedback. Very much appreciated

  • @ExcelUpNorth
    @ExcelUpNorth ปีที่แล้ว +1

    That is very cool! I appreciate you building the formula up step-by-step! Thanks!

    • @ExcelMoments
      @ExcelMoments  ปีที่แล้ว +1

      It is my pleasure. Thabks for the feedback

  • @joelabacherli1310
    @joelabacherli1310 หลายเดือนก่อน

    Great idea. This is a perfect work around to using a “slicer” in the filter function. I love this concept. Slicers are great but you can customize that selection section a million ways. Thank you for this great content. I will be integrating this into my projects for sure.

    • @ExcelMoments
      @ExcelMoments  8 วันที่ผ่านมา

      Glad it was helpful!

  • @davidakomolafe3609
    @davidakomolafe3609 ปีที่แล้ว

    Simple yet insightful. Thank you

    • @ExcelMoments
      @ExcelMoments  ปีที่แล้ว

      We agree on something!!!, so it is simple 😀

    • @davidakomolafe3609
      @davidakomolafe3609 ปีที่แล้ว

      @@ExcelMoments you make it look simple actually. I would never have thought of it that way

  • @nadermounir8228
    @nadermounir8228 ปีที่แล้ว +1

    Thank you for this insightful Video 📹

    • @ExcelMoments
      @ExcelMoments  ปีที่แล้ว

      It's a pleasure. Thanks for the feedback

  • @markpodesta4605
    @markpodesta4605 ปีที่แล้ว

    Thank you Victor.

  • @Bhavik_Khatri
    @Bhavik_Khatri ปีที่แล้ว +1

    Wow, very nice technique. 👍

  • @usmaniqbal1836
    @usmaniqbal1836 ปีที่แล้ว +1

    Perfect Victor 👌

  • @francisokoye5088
    @francisokoye5088 ปีที่แล้ว +1

    MVP 🔥🔥🔥

    • @ExcelMoments
      @ExcelMoments  ปีที่แล้ว

      My Prof, you are the man on fire

  • @surekantbangalore3499
    @surekantbangalore3499 ปีที่แล้ว

    SUPER TRICK. I ENJOY YOUR VIDEOS. PLEASE MAKE FURTHER THIS LOGIC FORMULA EXAMPLES PLEASE.

    • @ExcelMoments
      @ExcelMoments  ปีที่แล้ว

      Thank you for your feedback. Logic formula examples seem to be the theme of my channel, so i will surely make more

  • @crispexcel
    @crispexcel ปีที่แล้ว

    Lovely!

    • @ExcelMoments
      @ExcelMoments  ปีที่แล้ว +1

      i think so too, since it uses the FILTER function 😁

    • @spilledgraphics
      @spilledgraphics ปีที่แล้ว

      @@ExcelMoments are great ExcelMomhments.