Why You Should Use Sort Formula in Excel ?

Поділитися
Вставка
  • Опубліковано 1 лис 2020
  • 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 UA-cam 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

КОМЕНТАРІ • 133

  • @DeepakEduWorld
    @DeepakEduWorld  3 роки тому +5

    *My New Channel :* bit.ly/3qFrbl5
    *Complete Microsoft Word Tutorial :* ua-cam.com/video/Xkq0-xXAj48/v-deo.html
    *Complete Powerpoint Tutorial :* ua-cam.com/video/OekrBhNybP0/v-deo.html
    *Xlookup Complete Tutorial :* ua-cam.com/video/0LjfRVD7srU/v-deo.html
    *Vlookup Complete Tutorial* : bit.ly/2K0C1Sb
    *Excel All Formulas :* ua-cam.com/video/C9y53fedo04/v-deo.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 .....😊❤️

  • @suniljaiswal8869
    @suniljaiswal8869 8 місяців тому +1

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

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

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

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

    Very very helpful video sir thankyou so much

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

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

  • @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

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

    Excel ke jaisa kuch nhi ....great bhai

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

    Outstanding work

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

    you make excel interesting

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

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

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

    Beautifully explained

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

    Great ...Very well explained sir.. Thanks

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

    Superb man. Salute to you.

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

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

  • @MHamza-gn1bf
    @MHamza-gn1bf 3 дні тому +1

    thank so much

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

    Zabardast bhai...Sort +Filter

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

    Very nice way of teaching
    Thank you Deepak ji

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

    Deepak ji,
    Thanks very informative.

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

    thanks for your valuable informative video

  • @sangeetabhatnagar738
    @sangeetabhatnagar738 Місяць тому

    Excellent teaching..thank u sir

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

    Great job.I learn a lot from your videos.

  • @analyticsvidhya1
    @analyticsvidhya1 3 місяці тому +1

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

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

    good video.We learn fast .

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

    You are a great mr deepak

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

    Favourite channel 😊

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

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

  • @GopiNath-fp5ly
    @GopiNath-fp5ly 3 роки тому +1

    Very well explained.

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

    Very interesting sir, thank you very much

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

    Very helpful topic 👍 nice Video

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

    U R GENIUS SIR

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

    Very useful video. Thank u sir

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

    Jabardast and very useful vidio

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

    Great!!! Thank you.

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

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

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

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

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

    Really helpful 👍👍👍

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

    EXCELLENT!!

  • @SunnyKumar-cy1pw
    @SunnyKumar-cy1pw 2 роки тому

    Great video

  • @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 ❤️

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

    Wow sir amazing formula

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

    Nice video 📹👍

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

    Very informative

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

    Nice topic 👍

  • @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*

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

    Excellent sir👍

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

    Thank you

  • @feniljani5516
    @feniljani5516 5 місяців тому

    Excellent

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

    I like this video very much
    Thanks thanks thanks bhai

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

    thanks for Teach

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

    Superb

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

    Great

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

    Very nice formula

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

    Thank You Sir

  • @abhishekmoruya6026
    @abhishekmoruya6026 3 роки тому +3

    Fav. Chanel♥️

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

    Good job

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

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

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

    Thanks sir 🙏🙏🙏

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

    sir you are a best teacher love from karachi pakistan

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

    Good job sir

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

    awesome

  • @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

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

    Good sir

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

    Good bro

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

    👏👏👏

  • @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???

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

    Make video on Aggregate function with different criteria

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

    Sir make videos on Ms access also plse

  • @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?

  • @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

  • @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

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

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

  • @SatishGupta-vi7pv
    @SatishGupta-vi7pv 3 роки тому

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

  • @a.stechnicalboss7222
    @a.stechnicalboss7222 3 роки тому +2

    Sir excel vba series pr video banao plz

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

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

  • @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.

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

    From which excel version we can this function

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

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

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

    sir excel2016 main sort function hai kya???

  • @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

  • @RajeshKumar-dh4it
    @RajeshKumar-dh4it 3 роки тому

    Sir word me page layout se aage video kab banaoge.

  • @mukundraverkar4009
    @mukundraverkar4009 День тому

    Which is version is above Office 365 please.

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

    👌👌👌👌👌👌👌

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

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

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

  • @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)???

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

    ❤️❤️❤️

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

    Good good good

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

    Sir how to use dat validation without duplicate list?

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

    Sir, I Use Office 2019 but the sort formula is not seen here. I will benefit it the solution is given.

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

    Deepak bhai excel ka full tutorial wala link bhejo na

  • @goaussk.sknoor6235
    @goaussk.sknoor6235 3 роки тому

    Kis office version mein yeh available hoga

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

    wow sup up..!

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

    Sir, I always waiting your latest vdo and mush watch, I am in Dubai and need your help regarding I want to manage daily sales profit expenses of our shops we have 5 shops and also upload or forward daily progress to our owner, can you help me this regard

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

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

  • @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.

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

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

  • @SanatanIndiaQuotes.
    @SanatanIndiaQuotes. 3 роки тому

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

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

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

  • @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

  • @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