Searchable Drop Down List in Excel in Tamil

Поділитися
Вставка
  • Опубліковано 28 сер 2024
  • How to Create Searchable Drop Down list in Excel step by step Tutorial.
    Click the Link below to learn. (Subscribe for more upcoming Tutorials)
    xlookup Function in excel in Tamil
    • xlookup Function in ex...
    Drop Down list in Excel in Tamil
    • Drop Down list in Exce...
    How to Unprotect Excel Sheet without Password in Tamil
    • How to Unprotect Excel...
    #exceltutorialtamil #endlessknowledge

КОМЕНТАРІ • 113

  • @EndlessKnowledge
    @EndlessKnowledge  3 роки тому +8

    Don’t Forget to Follow:
    twitter.com/EndlessKnowled1
    facebook.com/enlessknowledge
    instagram.com/end_less_knowledge

    • @AshokKumar-ln8xx
      @AshokKumar-ln8xx 3 роки тому

      Sir pls make a video on how to use filter formula on office 2019 crak version 🙏🏻please....

    • @fero___3005
      @fero___3005 2 роки тому

      Bro neenga enna job panringa ?

    • @EndlessKnowledge
      @EndlessKnowledge  2 роки тому +1

      Web developer...

    • @vidhsri4145
      @vidhsri4145 Рік тому

      @@EndlessKnowledge which company bro?

  • @hasanmeeran5790
    @hasanmeeran5790 3 роки тому +31

    Dear brother வணக்கம் formula எழுதும் போது zoom செய்து காண்பித்தால் நலமாக இருக்கும் வாழ்த்துக்கள்.

    • @sathyapillari4194
      @sathyapillari4194 2 роки тому

      Clarity of screen and text is low. Please improve. 🙏

  • @MrsMg-lc7ie
    @MrsMg-lc7ie 3 роки тому +2

    👌 ரொம்ப நாளா யோசிச்சிகிட்டு இருந்தேன்...இப்போ கிடைச்சிருச்சி...நன்றி Endless Knowledge

  • @housekeeptech5504
    @housekeeptech5504 11 місяців тому +1

    You are the real teacher. Your voice and teaching techniques very unique. Please go ahead as you are. Thank you.

    • @EndlessKnowledge
      @EndlessKnowledge  11 місяців тому

      Thank you so much... Keep Learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html

  • @searchingbirds2362
    @searchingbirds2362 3 роки тому +2

    super explanation, thank you brother, excel all function work? and new function believe with ours, thankyou , by Searching Birds

  • @Ariii_ella
    @Ariii_ella Рік тому

    Thank you bro, Romba nandri. From Colombo, Sri Lanka. I got the exact formula I wished. All the best for your future endeavours. Riyaz

  • @princebabu3265
    @princebabu3265 3 роки тому +1

    நன்றி சார்..😊
    நீங்க ஃபார்முலா கொஞ்சம் ஜூம் பண்ணி காமிச்சா நல்லா தான் இருக்கும்.😊
    வாழ்த்துக்கள்.....😊
    லிங்கா நீக

  • @DrCivil-is6fs
    @DrCivil-is6fs 3 роки тому +2

    But, இது எதுவும் போடாமலே google sheets la search result வருது..
    ஆனால்,நீங்க சொன்ன formulas எல்லாம் Very useful...
    Vb macro coding video போடுங்க sir pls.. 🙏

  • @poovarasanj2622
    @poovarasanj2622 3 роки тому

    Your knowledge sharing is good. Share this to endless. 👍👍👍👍💐💐💐

  • @officetricks6303
    @officetricks6303 2 роки тому

    Wow Great job! your are really a master teacher of Excel.

  • @sathyanarayanansatagopan9069
    @sathyanarayanansatagopan9069 3 роки тому +1

    Thank You Sir! Very good explanation.

  • @nagarajan3451
    @nagarajan3451 Рік тому +1

    Great... And my requirement is Searchable Drop-down list in Entire column/ Multiple Cells. What I do sir... ???

  • @alagarsamy5579
    @alagarsamy5579 3 роки тому +2

    Bro resume create panrathu pathi video podunga

  • @muthulakshmis3891
    @muthulakshmis3891 3 роки тому +2

    Filter function is not available in ms excel 2019. Please tell another option

  • @ramananstevesmith7949
    @ramananstevesmith7949 3 роки тому +1

    Good Work bro 🔥🔥Keep Doing more🥰🥰

  • @mydearviewers9975
    @mydearviewers9975 Рік тому

    Vera level bro Nenga

  • @RahulRahul-mn2jr
    @RahulRahul-mn2jr 3 роки тому

    Neenga Vera level na ❤️🔥

  • @nktrendings816
    @nktrendings816 3 роки тому +1

    Super Learning Bro

  • @SAKTHIVEL-cm5ej
    @SAKTHIVEL-cm5ej 3 роки тому

    Sir, Kindly display fomula in bigger size, using formulatext function which will help us in a greater way... thanks

  • @Joubar_Sathiq
    @Joubar_Sathiq 3 роки тому

    Vera Vera Vera Level Bro..

  • @rajeshdass8005
    @rajeshdass8005 3 роки тому +1

    Super sir...Thank you....

  • @mohamedshifan748
    @mohamedshifan748 Рік тому

    Thank you for valuable content. Can we do this searchable drop down list and source data in same sheet?

  • @englishvlog1526
    @englishvlog1526 2 роки тому +1

    2010 and 2013 excel LA searchable list create pana =filter formula ila bro....so vera option ethashu eruka...solunga bro
    2010 la filter option ila
    2013 la filterxml option tha eruku...bro
    Any other ways eruntha solunga bro

  • @indhu4765
    @indhu4765 3 роки тому +1

    Multi column filter m same method la panalama bro??

  • @devisabarna1728
    @devisabarna1728 3 роки тому

    Thank you. It helped a lot

  • @roomyahamed1787
    @roomyahamed1787 Рік тому

    நன்றி நண்பா ❤️

  • @karthi.keyan.6681
    @karthi.keyan.6681 3 роки тому

    Very nice bro.

  • @jaideepkannan373
    @jaideepkannan373 3 роки тому +1

    Bro, How to include excel icon with link inside an excel sheet?
    When we click on that excel icon, a new sheet / excel book should open.

  • @t10v9
    @t10v9 6 місяців тому

    Sir oru word find pannayila antha row full ah hilight panni kamikara mathiri short cut irukka

  • @ManojKumar-xv3kr
    @ManojKumar-xv3kr 3 роки тому +1

    Power BI pathi start PANUNGA BRO

  • @praveenkumar-yl4oe
    @praveenkumar-yl4oe 3 роки тому

    Really good

  • @vimall5509
    @vimall5509 4 місяці тому

    1.5k🎉

  • @farookmaricar9400
    @farookmaricar9400 3 роки тому

    Appreciated bro

  • @isaivaniarumugam9395
    @isaivaniarumugam9395 Рік тому

    Superbbbbbbb....

    • @EndlessKnowledge
      @EndlessKnowledge  Рік тому

      Glad you liked it... Keep learning more about excel important functions ua-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html

  • @sukumarrajamanickam8468
    @sukumarrajamanickam8468 Рік тому

    Whether arguments enter in search results or in next page a3 cell?

  • @SakthiVel-lg2xw
    @SakthiVel-lg2xw 3 роки тому

    Hi Anna neenga MS EXCEL Aha oru webinar aha conduct pannunga anna

  • @sumankumar-qd8nc
    @sumankumar-qd8nc 11 місяців тому

    sir nan index and match function use panna enaku pakkathu cell ah work aguthu ana antha data ku left side work agamatuku.. nan kodutha formula apadiye katuthu.. itha epadi slove panna

  • @veerakumar6031
    @veerakumar6031 8 місяців тому

    Sir intha searchable drop-down list single cell matum tha work aguma ela entire column la work aguma

  • @anbarasum4634
    @anbarasum4634 10 місяців тому

    Bro I am unable to get suggestion names in drop-down box for example if in drop-down list I have 3 names like Praveen , pranav, pavi if I enter letter "pra" at that time I cannot get suggestion like Praveen, pranav, pavi . So I go to drop-down box and click Praveen. Why I am not getting suggestion list bro.

  • @accountsbanashalomcomercio5039

    You have given only one Cell Searchable Drop Down List. But can you Explain me how to make searchable Drop Down list for Multiple Cell or Column ????? waiting for you

  • @gopinathshanmugam1395
    @gopinathshanmugam1395 3 роки тому

    can the searchable dropdown list can be made in excel 2016

  • @rkraghu8623
    @rkraghu8623 Рік тому

    It's available in only Microsoft 365....?

  • @LinuxSaravanan
    @LinuxSaravanan Рік тому

    Sir, you explain this video based on Sheet 1, Cell A3, what about if I need A4, A5, A5,,,,,,,,,

  • @SalemNewschannel
    @SalemNewschannel 3 роки тому

    Super bro

  • @balajivenkatesan1543
    @balajivenkatesan1543 10 місяців тому

    Bro enaku like intha Mari varu thu =search(e,balaji) kodutha approm 1 nu oru varuthu balaji la 'e' nu oru word ye illa value nu thana varanu but 1 nu varu..ithu eppadi crt pandrathu pandrathu konjam soillunga

  • @mohanbalu4933
    @mohanbalu4933 Рік тому

    Bro,if Xlookup and Filter formulas not available in my system, how to do this formulas. My system is Windows 10 - 68 bits and office 365 - 2019.

  • @dineshravi7659
    @dineshravi7659 3 роки тому

    Hi bro cnc coding video podunga bro

  • @ezheel
    @ezheel Рік тому

    The drop-down does not update instantly if the sheet is protected. After entering the value you need to move the course to a different cell then only its drop-down is updated in the search results.

  • @dhamayanthidhamayanthid2188
    @dhamayanthidhamayanthid2188 2 роки тому

    is this workable for account number search?

  • @soundaryasuresh1845
    @soundaryasuresh1845 6 місяців тому

    Pls upload practice file sir

  • @jiya2907
    @jiya2907 Рік тому

    2010 filter function vunda sir athu eppudinu solluga

  • @Sivabalaji1310
    @Sivabalaji1310 2 роки тому

    Bro I need exercise? For practice

  • @user-fk7tv2tt5t
    @user-fk7tv2tt5t 10 місяців тому

    thala ctrl+shift+down kudutha oru line la tha answer varuthu select panna y
    ella row kum vara matikuthu why ?

  • @user-qk4pq9pe4v
    @user-qk4pq9pe4v 2 роки тому +2

    ஒரு Column முழுவதும் Searchable Drop Down List வேண்டும். என்ன செய்ய வேண்டும்?

  • @manna8473
    @manna8473 3 роки тому

    Anna indirect formula explanation

  • @sathyanathan3370
    @sathyanathan3370 3 роки тому

    Neenga use panrathu excel 2007aa

  • @saralogtistics1846
    @saralogtistics1846 Рік тому

    I HAVE DONE THIS IN MY DESKTOP AT HOME AND IT WAS SUCCESSFUL. THEN I WHATS-APP THE WORKSHEET TO OFFICE. THEY DOWNLOADED IT BUT NOT WORKING THERE. I FOUND OUT THAT THE FILTER FUNCTION IS NOT IN THOSE EXCEL SHEETS. WHEN WE GIVE =FILTER IN THE CELL THAT OPTION IS NOT APPEARING. HOW DO I INSERT FILTER FUNCTION TO THOSE EXCEL VERSIONS. WE ARE USING MICROSOFT EXCEL 2010

  • @sugunachandran1263
    @sugunachandran1263 3 місяці тому

    Sir how to create searchable drop down list in Excel 2016

  • @OneLove.One_Life
    @OneLove.One_Life Рік тому

    Bro template share pannuga full ha

  • @vijayasankar8434
    @vijayasankar8434 3 роки тому

    I need you useing ms office version details

  • @renganathanvenkatchalam9210
    @renganathanvenkatchalam9210 3 роки тому

    sir
    Please clarify to me. I have tried the searchable data, everything is ok, but I want to one clarification regarding that the only one cell are filled another cells is not filled automatically, pleae help

  • @anbudigitalmalvoi.9326
    @anbudigitalmalvoi.9326 3 роки тому

    Pro wondershare flimora video poduga pro

  • @satheeshkumar646
    @satheeshkumar646 6 місяців тому

    filter function not shown excel sheet sir

  • @manna8473
    @manna8473 3 роки тому

    Anna Offset formula explain

  • @pdvshaik3300
    @pdvshaik3300 3 роки тому

    Bro Oru Cell la Ulla Number re, Athe Cell lulaiye Epdi kali Kalikkirathu ...

  • @thangaveluraj
    @thangaveluraj Рік тому

    What about those who use Excel 2010 or below??

  • @panamaxramsfittings1586
    @panamaxramsfittings1586 2 роки тому

    Sir in my Excel filter formula is not available.

  • @kaizenbalu
    @kaizenbalu 2 роки тому

    filter function is not available only filterxml function only available

  • @crazyeditz942
    @crazyeditz942 7 місяців тому

    F4 key lock agala ms excel 2013 selection lock epdi panrathu

  • @pugazhpugazhenthi8545
    @pugazhpugazhenthi8545 Рік тому

    How add data in dropdown bro

  • @RajaAndrew
    @RajaAndrew 3 роки тому

    Filter function is not available in MS office 2019... any alternative function?

    • @khizarhussain6523
      @khizarhussain6523 2 роки тому +1

      @Endless Knowledge plse reply on this i too have same concern !

    • @pandian2001
      @pandian2001 2 роки тому

      @@khizarhussain6523 subcription needed

  • @ENNAM_POOL_VALKAI
    @ENNAM_POOL_VALKAI 2 роки тому

    Search ah VBA la try panna mudiuma bro

  • @srinivasanv9677
    @srinivasanv9677 2 роки тому

    Dear sir enoda Excel la filter Elia sir..

  • @SathishKumar-vy4oi
    @SathishKumar-vy4oi Рік тому

    Sir 2010 Filter function varala

  • @lovely8157
    @lovely8157 3 роки тому

    Bro pls java podunga bro pls....🙏🙏

  • @subramaniyant1108
    @subramaniyant1108 2 роки тому

    Filter option not come bro

  • @murugesanmani6460
    @murugesanmani6460 2 роки тому +1

    =FILTER comments not available in 2016 version

  • @vijaymecheng
    @vijaymecheng 3 роки тому

    Sir How to enable filter formula in ms office 2019..my spreadsheet filter formula not working sir

  • @balajivenkatesan1543
    @balajivenkatesan1543 10 місяців тому

    And also filter nu oru function ye enaku varamatikithu

  • @kesavguru415
    @kesavguru415 3 роки тому

    2nd comment

  • @ponmadasamyranjan12
    @ponmadasamyranjan12 2 роки тому

    I tried many times, but i didn't get the results.

  • @vickym7112
    @vickym7112 3 роки тому

    Excel ஹிஸ்ட்ரி க்ளீயர் பண்றது எப்டின்னு சொல்லுங்க ப்ரோ

  • @arunaagencies8896
    @arunaagencies8896 Рік тому

    i dont get filter noption.. plz help me sir

  • @vadivelayyasamy9862
    @vadivelayyasamy9862 6 місяців тому

    Filter function ae ennoda excel la varla bro

  • @sumankumar-qd8nc
    @sumankumar-qd8nc 11 місяців тому

    sir filter formula not showing

  • @karthi.keyan.6681
    @karthi.keyan.6681 3 роки тому

    Google sheet la once drop-down list create pannita automatic Ha searchable drop down list ha maridum.

  • @RajKumar-Kavithaigal
    @RajKumar-Kavithaigal 2 роки тому

    Bro enakku open office video anuppinga bro please

  • @vigneshj7437
    @vigneshj7437 3 роки тому

    👏👏👏👏👏🤝

  • @anzanzpc5895
    @anzanzpc5895 3 роки тому

    BRO EXCEL LA FILTER OPTION ELLA. YENA PANANUM

  • @Vangipuram
    @Vangipuram 3 роки тому

    you yahe excel file for download