Automatic Filter in Excel (Hindi)

Поделиться
HTML-код
  • Опубликовано: 15 окт 2024
  • Automatic Filter in Excel (Hindi)
    In this video you will learn how to create an automatic filter. You can filter anything which you type in search box. No VBA coding has been used. It is created with the help of Conditional Formatting and Excel Marco.
    If you find this video valuable please subscribe our channel:
    / powerexbyjitendra
    You can download our file:
    ==============================
    drive.google.c...
    ==============================
    Related Videos:
    1. How to use Subtotal Function in Excel
    • How to use Subtotal Fu...
    2. Conditional Formatting with Formula in Excel
    • Conditional Formatting...
    ----------------------------------------------------------
    Other Videos on Filter
    1. Filter Data Automatically in Excel (Hindi)
    • Filter Data Automatica...
    2. Filter Data Dynamically in Excel (Hindi)
    • Filter Data Dynamicall...
    3. Filter Data Betweeen Two Dates in Excel
    • Filter Data Betweeen T...
    4. How to Filter Top 10 / Top 5 Values Automatically in Excel
    • Automatic Filter in Ex...
    5. Search Box in Excel by using Advanced Filter and Macro
    • Search Box in Excel by...
    _____________________________________
    Playlists of our top videos:
    1. Stock Management System in Excel
    • Stock Management Syste...
    2. Advanced Excel Formulas
    • Advanced Excel Formulas
    3. Awesome MS Word Videos
    • MS Word
    -----------------------------------------------------------
    Gear I Recommend:
    -----------------------------------------------------
    1. Mice: amzn.to/3I2stPd
    2. Mobile Tripod Mount: amzn.to/33gR8kh
    3. Gurilla Tripod: amzn.to/3FqwsmT
    4. amzn.to/3npWu3C
    5. Tripod: amzn.to/3I4P3GV
    6. Wireless Bluetooth Headphone: amzn.to/3K8XUcl
    Video is created by Jitendra
    Published on Powerex by Jitendra
    Language of this tutorial is Hindi.
    #filterdata
    #powerxbyjitendra
    #excel
    Subscribe on Telegram:
    t.me/powerexby...
    Contact Us:
    Instagram: ...
    Facebook : / powerex-by-jitendra-10...
    Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research.
    Fair use is a permitted by copyright statute that might otherwise be infringing.
    Non-profit, educational or personal use tips the balance in favor of fair use.
    Thanks

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

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

    आपण खूप सुंदर व्हिडीओ बनवून ज्ञानात भर घालत आहात सर. Thaks

  • @s.m5793
    @s.m5793 2 года назад +2

    Thanks you, Sir. You have done a great help to me with this tutorial that I was looking for. Gratitude to your precious effort and commanding voice.

  • @toobanadeem2888
    @toobanadeem2888 Год назад

    informative keep sharing

  • @karthikeyanb7517
    @karthikeyanb7517 8 месяцев назад

    Really good demonstration...

  • @BalvirSingh-qs9kz
    @BalvirSingh-qs9kz 2 месяца назад

    Sir, very nice. Sir data table me neeche feed karenge to filter hoga?

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

    It's working bro.. Thanks

  • @rakeshvermadipr
    @rakeshvermadipr Год назад

    Very helpful tutorials...thanks a lot

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

    Excellent 👌 Amazing. Thanks alot Sir

  • @manikumar7166
    @manikumar7166 8 месяцев назад

    Sir, es video me Singal search kr sakte h...agar bhut Sara name ko search ek click me kaise krenge....
    For example- agar es sath Delhi, Lucknow, agar ho to kaise krege....

  • @ta20111996
    @ta20111996 Год назад

    Excellent, but this is for limited data purposes, if you increase data then how will be performed by this formulas???

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

    Thank u sir ....iske jagah per advance filter bhi laga sakte hai with macro record ..😀

    • @PowerExbyJitendra
      @PowerExbyJitendra  2 года назад +2

      Usme aap kisi bhi field ko filter nahi kar sakte

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

      @@PowerExbyJitendra sabhi fields ka filer ho jata h sirf macro se Karne per 😐

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

      @@Altaf_Alam ruclips.net/video/T6r90K1GwZY/видео.html

  • @rocket-lf9rm
    @rocket-lf9rm 2 года назад

    Will this method work if there is many heading but same after 50 to 60 student name like student name old balance fees heads like

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

    Superb information

  • @tt_badmash_9560
    @tt_badmash_9560 Год назад

    Excellent sir

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

    Excellent زبردست

  • @sarvodayaconventvidisha1757
    @sarvodayaconventvidisha1757 Год назад

    जबरदस्त

  • @AftabAhmed-uw4ki
    @AftabAhmed-uw4ki 2 года назад

    Sir g what a beautiful this trips

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

    Thank you.. Please do multiple automatic filter in same sheet

  • @narendrajaiswal9471
    @narendrajaiswal9471 Год назад

    Very good

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

    Video bhot achi ha laikn jab live data enter krna ho to pir kya method ho ga. q k ya method to sirf paly say data enter ho us k liayay ha

  • @SanjeevChhajer
    @SanjeevChhajer Год назад

    Can we set if we want particular columns showing micro recording in adance filter (if have data text or 1 then show the same columns and if show 0 in columns thisn hide) pls advice

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

    Nice tutorials .can u guide how to modifying data base In form . I mean s once data enter in data base how to create modified button ?

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

    Sir please sath me excel version b mention kr dia kren

  • @vishalagrawal8717
    @vishalagrawal8717 Год назад

    It's good but too much lengthy... I need to apply in almost all workbook and sheet so I can't use this formula but kudos to ur work....

  • @acscablenetwork8562
    @acscablenetwork8562 22 дня назад

    Boss Save krna ka Bad Micro work nhi kr raha hai same save kiya hai jo aap na samjha hai

  • @harwinderbrothers6779
    @harwinderbrothers6779 7 месяцев назад

    Sir ji jo data enter kr deya ho usa koi delete na ker ska .delete khud hum kr ska koi Selutions do

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

    क्या इसे VBA की सहायता से और आसानी से कर सकते हैं ?

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

    Very nice 👍

  • @khalidchadhuary4368
    @khalidchadhuary4368 Год назад

    Agr mobile mein yeah use krna hoo toh kaisey use Hoga ...wahan toh nhi chalta

  • @narendrajaiswal9471
    @narendrajaiswal9471 Год назад

    क्या बिना मैक्रो के ये काम नही होगा ,,?

  • @SpentikaCeramic
    @SpentikaCeramic Год назад

    CAN I FILTER 2 OR 3 CITY AT A TIME? ANY VIDEO IS THERE?

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

    Sir CAN WE DELETE G COLUMN DATA?

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

    Excellent

  • @offcialsupervisor758
    @offcialsupervisor758 Год назад

    Thanks

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

    Good

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

    Hello sir
    Please help to me how can I send auto email base on date match.
    Thank you

  • @art-and-craft.
    @art-and-craft. 2 года назад

    file download krne par macro disabled ho ja raha hai, or kuch bhi work nahi kr raha

  • @Mindfulphilosophy108
    @Mindfulphilosophy108 Год назад

    automatic filter color background cell

  • @shahumer9006
    @shahumer9006 Год назад

    Its not working when sheet protected

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

    How to get" list index name" on combobox vba excel
    Example: Select Country

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

    DATA EK SHEET MEIN FILTER SECOND SHEET KAISE KARIEN WITH BETWEEN SELECT FROM AND TO DATE

  • @muhammadhamzakaleem-mu3ki
    @muhammadhamzakaleem-mu3ki Год назад

    It's doesn't work in protect sheet

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

    User form make 🙏
    Save,update, delete,imge ,print button use sir 🙏😔🙏

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

    You can do the same thing without macro

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

      Please download file from description box and send back to me, by doing it without macro. My mail address is given in about section.
      I will wait for your response.

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

      @@PowerExbyJitendra I sent you mail

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

      @@canirmalchoudhary8173 not received. Just checked

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

      @@PowerExbyJitendra ruclips.net/video/d4Q5HIDsVbk/видео.html

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

    Exercise Rapidly, Please

  • @narendrajaiswal9471
    @narendrajaiswal9471 Год назад

    मैक्रो मुझे एक्स्ट्रा लग रहा है शायद

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

    Nahi samja vdo..at first batana chiya kiya vdo ha starting se

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

    Thanks you, Sir. You have done a great help to me with this tutorial that I was looking for. Gratitude to your precious effort and commanding voice.

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

    Good