VLOOKUP Mastery: MAX & MIN Functions You Need to Know!

Поділитися
Вставка
  • Опубліковано 1 гру 2024

КОМЕНТАРІ • 27

  • @Excel_Tutorial
    @Excel_Tutorial  10 днів тому

    Get Free Notification for Upcoming Videos = forms.gle/kXmk3Tp5SKhuhC5Q9
    Join our telegram group to get Practice file : t.me/learnmoreindia/1731
    V-lookup Playlist: ua-cam.com/play/PLLD1o3p3r3-1OZ5--Aht1kH8ut1l9Bb29.html
    Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/

  • @awadheshkumarchauhanchauha7244
    @awadheshkumarchauhanchauha7244 8 днів тому

    Thanks sir

  • @Mdaslam-id8zi
    @Mdaslam-id8zi 10 днів тому

    Very useful video sir.

  • @Pradeep_Sharma_Ji
    @Pradeep_Sharma_Ji 9 днів тому

    Column 4

  • @ManpreetKaur-hx8nj
    @ManpreetKaur-hx8nj 10 днів тому

  • @anilmathangi1591
    @anilmathangi1591 10 днів тому

    Sir please make video on vlookup+choose+match

  • @vishalgurav950
    @vishalgurav950 7 днів тому

    Sir 2 sheet hai, 1 hai sales sheet month of October 24 and 2nd sheet me 12 GST number hai to vo 12 number muje 1st sheet me search krne hai, vo 12 GST number ko October 24 me kitni bar sales Kiya hai ye dekhna hai to konsa formula apply krreee

    • @Excel_Tutorial
      @Excel_Tutorial  7 днів тому

      1. Sales sheet (October 24): Yahan par aapka data hoga jisme GST numbers ka column hoga. Maan lijiye GST numbers Column A mein hain.
      2. GST numbers sheet: Yahan par aapke paas 12 GST numbers hain (maan lijiye yeh numbers Column A mein hain).
      Agar aap GST number sheet ke first GST number ko October sales sheet mein dhoondhna chahte hain, to aap COUNTIF formula ka use kar sakte hain.
      1. Sales sheet (October) mein ek naya column (maan lijiye Column B) add karen.
      2. Ab B2 cell mein yeh formula apply karen (agar aapka first GST number GST numbers sheet mein A2 cell mein hai):
      =COUNTIF('October Sales Sheet'!A:A, 'GST Numbers Sheet'!A2)

  • @muhammadshahbaz5021
    @muhammadshahbaz5021 10 днів тому +1

    Dynamic Horizontal vlookup ka answer sahi nahi aa raha hai sir me bahut pareshan hu

    • @Excel_Tutorial
      @Excel_Tutorial  4 дні тому +1

      Please watch the video carefully, and you will understand the steps. 😊

  • @kailashchandrasharmaro2711
    @kailashchandrasharmaro2711 10 днів тому

    3

  • @navnaththorat2445
    @navnaththorat2445 3 дні тому

    एक्सेल मध्ये A कॉलम मधे असलेला डेटाप्रमाने , B कॉलम मधे असलेला तोच डेटा पण रो वर खाली असलेला डेटा A कॉलम प्रमाणे कसा जुळवावा ?

  • @raviyadav-sl2mn
    @raviyadav-sl2mn 7 днів тому

    Column index 4hoga

  • @crazyboy-tx3eg
    @crazyboy-tx3eg 6 днів тому

    Sir ek help chahiye

  • @alokagarwal5654
    @alokagarwal5654 10 днів тому +1

    If we use xlookup instead of vlookup, will the problem still exist.

  • @YTShortsOfficial
    @YTShortsOfficial 9 днів тому +1

    Table range galat select Kiya hai understand, kyon ki aapne jhan par minimum ka formula lagya hai wahin se hi select karna he table range ko aur aage name tam select karna he aai baat samajh me thodi se video ke liye 4 ghante ka video bana diya

  • @muhammadshahbaz5021
    @muhammadshahbaz5021 10 днів тому

    Asif sir aap toh kehte ho ki main aap ke comment padta hu toh aap answer ka jawab kyu nahi de rahe ho

  • @rajkumarjain3697
    @rajkumarjain3697 10 днів тому

    Column index wrong

  • @Ramram18118
    @Ramram18118 10 днів тому

    Column wrong ❌

  • @muhammadshahbaz5021
    @muhammadshahbaz5021 10 днів тому

    Asif sir aap se baat na chahata hu please apna number send kar do sir

  • @ProfxTrading
    @ProfxTrading 9 днів тому

    Very useful video ❤

    • @Excel_Tutorial
      @Excel_Tutorial  4 дні тому +1

      It's my pleasure 🤩🤩🤩🤩🤩🤩🤩

  • @shaheersialvi5496
    @shaheersialvi5496 8 днів тому