Why You Should Use Sort Formula in Excel ?

Поделиться
HTML-код
  • Опубликовано: 16 сен 2024
  • Why You Should Use Sort Formula in Excel || Excel Formula and Functions || Hindi
    #deepakeduworld #excelformulas #excelfunctions
    In this video you will learn how to use excel sort formula which is new in office 365 and google sheets. here is detailed explanation of sort formula with unique and filter formula. The Excel SORT function sorts the contents of a range or array. Values can be sorted by one or more columns. SORT returns a dynamic array of results.
    Hope you will like the video. Thanks For Watching Friends.... Have A Nice Day...
    Deepak EduWorld Playlist's:
    ADVANCED EXCEL ► goo.gl/A6LdZA
    ADVANCED EXCEL FORMULAS ► goo.gl/bbHYu2
    Excel Tips & Tricks ► goo.gl/wAj1jh
    MS WORD ► goo.gl/B4TeSA
    HTML5 & CSS3 ► goo.gl/2PFgs8
    COMPUTER TECHNICAL videos ► goo.gl/paZmpn
    Automatic Invoice's in excel ► goo.gl/dFhg54
    Subscribe Deepak EduWorld ► / deepakeduworld
    Instagram ► / deepak__nehra
    Facebook page ► / deepakeduworld
    LinkedIn ► / deepakedu. .
    Facebook Group ► / cse92
    We Always Provide Useful & Helpful Content On The Deepak Eduworld RUclips Channel, Here MS Excel Tips And Tricks, And Tips And Tricks For MS Word, And Internet Tips And Tricks, Along With The Computer Related Useful Information In Simple Hindi Language. I You Can Visit Our Channel Playlist's. It Is Our Effort To Get This Information Useful For All Types Of Excel Users, MS Word Users, Computer Users And Internet Users.
    Tags : office 365,filter in excel,sort in excel,sorting data in excel,excel in hindi,sort function,new formula in excel,office 365 tutorial,sort formula in excel in hindi,excel formulas,sorting,sort with a formula,sort function in excel,sort data in excel,sort by formula in excel,excel sort formula,use of sort in excel,how to sort data in excel?,deepak eduworld,excel formulas and functions,learn computer,internet

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

  • @DeepakEduWorld
    @DeepakEduWorld  3 года назад +5

    *My New Channel :* bit.ly/3qFrbl5
    *Complete Microsoft Word Tutorial :* ruclips.net/video/Xkq0-xXAj48/видео.html
    *Complete Powerpoint Tutorial :* ruclips.net/video/OekrBhNybP0/видео.html
    *Xlookup Complete Tutorial :* ruclips.net/video/0LjfRVD7srU/видео.html
    *Vlookup Complete Tutorial* : bit.ly/2K0C1Sb
    *Excel All Formulas :* ruclips.net/video/C9y53fedo04/видео.html

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

      Thanks Deepak bhai

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

      Sir 1 video banaiye na ...jisme bataiyega 2 formula kaise combine karte hai .....mujhe samajh nhi aata ki 2 formula mein kise pehle dalege aur kise baad mein .....😊❤️

  • @anaghapradhan7745
    @anaghapradhan7745 Год назад +1

    you make excel interesting

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

    Favourite channel 😊

  • @sangeetabhatnagar738
    @sangeetabhatnagar738 4 месяца назад

    Excellent teaching..thank u sir

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

    Jio mere dost..... Deppak paaji , tussi great ho....love you. such a best explaination. You are real Guru....

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

    Good video , simple language , wasy to understand .
    keep making more such video.

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

    good video.We learn fast .

  • @faizarif5674
    @faizarif5674 3 года назад +5

    Sir, u doing a great job. I'm working in army & one thing which irks me a lot is when I copy data from word table & paste it in Excel. Many a times rows / coloums get merged. If u can plz help. Anticipating

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

    Aapke explain kerne ka tarika kamal hai sir.Thankyou for this usefull video.

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

    good video .
    keep teaching us .
    All the bst to you .

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

    Boss.. You are Genius.👍❤️❤️

  • @Dinesh-v1c
    @Dinesh-v1c 2 года назад +1

    thanks for Teach

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

    Excel ke jaisa kuch nhi ....great bhai

  • @abhishekmoruya6026
    @abhishekmoruya6026 3 года назад +3

    Fav. Chanel♥️

  • @vikasgawaria5330
    @vikasgawaria5330 Год назад +1

    Very very helpful video sir thankyou so much

  • @analyticsvidhya1
    @analyticsvidhya1 6 месяцев назад +1

    Great work brother, but next time try to make small and to the point video please

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

    Outstanding work

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

    Superb man. Salute to you.

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

    Very informative

  • @MHamza-gn1bf
    @MHamza-gn1bf 2 месяца назад +1

    thank so much

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

    Beautifully explained

  • @tech2expert870
    @tech2expert870 Год назад +1

    Thank you

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

    I like this video very much
    Thanks thanks thanks bhai

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

    You are a great mr deepak

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

    U R GENIUS SIR

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

    Good sir

  • @SunnyKumar-cy1pw
    @SunnyKumar-cy1pw 2 года назад

    Great video

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

    Zabardast bhai...Sort +Filter

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

    Nice topic 👍

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

    Great ...Very well explained sir.. Thanks

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

    Excellent

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

    Excellent sir👍

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

    Deepak ji,
    Thanks very informative.

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

    Very nice way of teaching
    Thank you Deepak ji

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

    Sir, aapka video sab se hat ke hota he. Very Nice. Very deep.

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

    Really helpful 👍👍👍

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

    Jabardast and very useful vidio

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

    Thankyou so much. This formula I am looking from long time and simply I got this from you. Thankyou.. 👍

  • @GopiNath-fp5ly
    @GopiNath-fp5ly 3 года назад +1

    Very well explained.

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

    Great

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

    thanks for your valuable informative video

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

    Very nice formula

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

    Good bro

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

    Superb

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

    Good good good

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

    Very helpful topic 👍 nice Video

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

    Good job

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

    EXCELLENT!!

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

    Thank You Sir

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

    Thanks sir 🙏🙏🙏

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

    Zabardast video, shayad mai jiski khojme tha wo pura to nahi lekin thoda mila. 👌

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

    Good job sir

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

    Very useful video. Thank u sir

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

    sort formula not active in excel. how can i get it active. Nice information. respect from Pakistan

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

    Nice video 📹👍

  • @syedfaraz1903
    @syedfaraz1903 Месяц назад

    Good

  • @mukundraverkar4009
    @mukundraverkar4009 2 месяца назад +1

    Which is version is above Office 365 please.

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

    "Awesome! you solved my big problem, thanks bro, my new question is that in stock exchange shows the upper cap and lower cap, there is any formula in excel "Agar kisi stock ki value upper cap per lock ho jaye, aur another cell main figure fix hojay, pher down value honey ki surat main dusrey cell main show karey kah is stock ka upper cap value, jis sey hum stock value ka 52 weeks malum kar sakein I hope you have got my point*

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

    Wow sir amazing formula

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

    awesome

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

    sir you are a best teacher love from karachi pakistan

  • @BISPCallCenter
    @BISPCallCenter Год назад +1

    Brother yeh konse excel version mein formulla apply hota hai wo bhi bata dia krein 2007 vresion mein to filter or sort name ka koi formula hai hi nahi please 2007 vresion k lye koi aisay formulas batain.

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

    Deepak bhai excel ka full tutorial wala link bhejo na

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

    Great job.I learn a lot from your videos.

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

    Great!!! Thank you.

  • @a.stechnicalboss7222
    @a.stechnicalboss7222 3 года назад +2

    Sir excel vba series pr video banao plz

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

    Excellent Sir
    Very Nice
    Om Sai Ram
    Sir Ye Bataiye Ki MS Office Latest Version 2019 ya Jo Bhi Ho, Wo Kitne Me Milta Hai, Aur Kya Ek Baar Purchase Karne Par Updates Humesha Milte Rahenge???
    Thanks

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

    Very interesting sir, thank you very much

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

    👌👌👌👌👌👌👌

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

    Nice sir ,i want to see the complete video of pvoit table with complete function thanks

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

    Sir agar alag alag column me dulpcate names ho to wo sab ek hi column me is formule se unique kaise hokar ayege plz help, agar aisa nhi ho skta is formule se to phir dusra method kya hai?

  • @mushahidali5958
    @mushahidali5958 5 месяцев назад

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

    Guru ji 1k humble request hai aap se. excel,ms words and power point yaa kai saare photo ki ppt kaise banate hai aise hai ki aap ish par amal jarur karenge....m

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

    Sir make videos on Ms access also plse

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

    👏👏👏

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

    Sort Formula Ms Office 2021 me mojod hai me ne use kya huwa hai

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

    Sar apki video bahot achi hai apsy help chay main ny time farmula lagya hai suba 6:00 bajy sy time estat hota hai agy 7 kalam hai jis main time likhna hai main chata hun jis main time likhun agy total time aa jay main ny asy farmula lagaya hai =SUM( B1-A1+C1-A1+D1-A1+E1-A1+F1-A1+G1-A1+H1-A1) YE SUM to karta hai par ak do kalam khali rakhun to etna time menas ho jata hai A1 main 6:00am likhta hun jo estat time hota hai

  • @Amazon-l2l
    @Amazon-l2l 3 года назад

    Sar maine axcel sikhna chahti ho sar pochna hai bank cashier k liye best hai yeh?

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

    wow sup up..!

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

    Office 16 me kya formula use kre sort krne ke liye ?????

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

      Hloo sir plzz tell me if any solution u have..

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

    sir excel2016 main sort function hai kya???

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

    Make video on Aggregate function with different criteria

  • @mohsinfahim3598
    @mohsinfahim3598 Месяц назад

    Brother salam ... i need a solution ..if i shift data automatically data from master sheet to remote sheet soo i need to eliminate the entries having a term consist of held. How v can use filter formula? I need ur kind guidence.

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

    Nice video 👍. But my question agar two date between ya current date say Kasey karain gay.

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

    Your videos are very helpfull and excellent.but if you can arrange your illustration in English, it will more help ful....

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

    Deepak ji. I have a one doubt. " How to move or copy 15 excell files into 15 excell sheets (one file)???

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

    Sort kiye data ko previous form me kaise la sake

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

    Sir how to use dat validation without duplicate list?

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

    hi, king of excel, I have a lot of Data in excel sheet, How do i do data will sort auto. please help me in this regards. I am using MS. OFFICE 2019.

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

    I have 1000 number of data in one sheet ie 1 to 10 standard 100 each, now I have to select top 25 data from each standard and want to paste in different sheets.. In there any shortcut way or formula for this task. Currently I am sorting it from filter menu and paste it to different sheets one by one standard. Please reply

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

    hello sirji, sort formula mere desktop mai nahi aa raha hai excel 2010. any other option?

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

    Really nice to see these videos teaching Excel.I also have some tutorials on youtube and I hope you'll find them useful! Much love and keep on learning ❤️

  • @SatishGupta-vi7pv
    @SatishGupta-vi7pv 3 года назад

    Hello, can you please make 1 video on full VBA & MACRO??

  • @RajeshKumar-dh4it
    @RajeshKumar-dh4it 3 года назад

    Sir word me page layout se aage video kab banaoge.

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

    Sir, how can we get this add ins in ms office 2010 professional. Also ms 365 online sheets doesn't have macros function???

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

    Name alphabetical order m filter hote hn , kya hum name ka order decide nhi kr skte, m chahta hu ki , a , b , c me se agar filter ya sort karu to b at 1, c at 2 , a at 3 aaye , and entry table should be filtered table itself

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

    Sir i want to learn make timetable in excel teacher wise, class wise and vacant period that works automatically and each one will be linked

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

    Deepak Vai, Is this formula only available in office 365??

  • @SanatanIndiaQuotes.
    @SanatanIndiaQuotes. 3 года назад

    Sir power bi ka tutorial dijiye mujhe bahut problem ho rha h

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

    Video Start At 3:05