MS Excel: How to Sort Value with Data (Large to Small & Ascending to Descending)

Поделиться
HTML-код
  • Опубликовано: 27 окт 2024
  • Sort Number & Data Large to Small & Ascending to Descending in Microsoft Excel..
    Facebook Page : / memjtube
    Follow on twitter: / mj1111983
    Website : www.bsocialshin...

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

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

    Thank you for this great tutorial. This helped me a lot today at work.

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

    Thank you for the great help. It helped me sorting numerically.

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

    Thankyou you make my work faster!

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

    Dear Sirm
    Thankyou Sir For Clearing My Doubts
    Best & Regards
    LOGESH N

  • @AdityaSingh-oz4lb
    @AdityaSingh-oz4lb Год назад +1

    Thank you so much sir

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

    Thank you very much💙

  • @RG-ud9ix
    @RG-ud9ix Год назад +1

    Thank you so much 🙏

  • @NorthernHigh
    @NorthernHigh 3 года назад +4

    The TaTa
    this was helpful thank you so much!!

  • @almeer.express
    @almeer.express Год назад +1

    Thank you.

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

    Man!! Thank you!!!

  • @Ben-pf4im
    @Ben-pf4im 2 года назад +1

    Thank you

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

    Thank you!

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

    How about payroll of the employees? The salary goes to different employees if only the number is clicked in sorting based on their gross pay.

  • @humaasif-2244
    @humaasif-2244 Месяц назад +1

    THANKSSS

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

    Great video, thanks!

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

    This work only when your figures have the same number of digits but if you mix 2, 3 , 4and 5 digit numbers it doesn't work. Excel arrange figures by decade, hundreds thousands etc...

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

    We are trying to sort rows in numerical order (we have about 70 rows with these type numbers below). We know that's doable in numerical order, however, the numbers are unusual. Her is an example of a column and each number is in a row:
    2-6-0
    2-10-2
    2-6-2
    4-8-2
    4-4-2
    2-8-2
    2-8-4
    2-6-4
    2-8-0
    0-6-0
    2-10-0
    The problem: The focus is on getting the middle number(s) all grouped
    together and then sorted in order with the first digit (and last digit)
    then being numerically sorted. We are trying to sort them like this in
    the column as an example:
    4-4-2
    0-6-0
    2-6-0
    2-6-2
    2-6-4
    2-8-0
    2-8-2
    2-8-4
    4-8-2
    2-10-0
    2-10-2
    Normal numerical sorting would not group these correctly like shown because it would use the first number as the sorting point.These numbers by the way are railroad steam engine designations for their wheel arrangements, for which I have about 70 vintage brass models of these in HO scale and I need to sort them correctly to find them easily on a spread sheet. There are 12 columns in our spread sheet (one column with the numbers above) and the other columns with other data like: manufacturer, whether factory painted, condition, w/original box, etc). Thanks and hoping there is a way to sort them. Thanks.
    Philip

  • @joellim7010
    @joellim7010 5 лет назад +1

    thanks. this actually works.

  • @kakarlavinayakam8159
    @kakarlavinayakam8159 4 года назад +2

    I want know the how to sort the data while using the formula. Thank you

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

    Thank u

  • @ShelliRayner
    @ShelliRayner 5 лет назад +2

    When I highlight the column to copy it auto fills the first row amount into all of the remaining rows with the same amount. What am I doing wrong?

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

      We both have the same case. Whenever I am sorting it from highest to lowest, the amount remains unsorted.

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

    thanks

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

    "and boom"

  • @kevinlkeys
    @kevinlkeys 4 года назад +1

    Thanks!!

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

    thx

  • @joahrmonserrate9965
    @joahrmonserrate9965 4 года назад +1

    Thank you❤

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

    This does not work😮

  • @ogj13
    @ogj13 4 года назад +1

    thank you 😊 🙏 !!!!!!!!!!!!!!!!!!

  • @sudheernambiar699
    @sudheernambiar699 5 лет назад +1

    where I can download practice files, please let me know

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

    how do i sort number plates a mix of numbers and letters to sort by the numbers not the letters

  • @umairahalip4185
    @umairahalip4185 4 года назад

    Thanks a lot

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

    thank you omg

  • @sikataktebu
    @sikataktebu 4 года назад

    what if there's a thousand there

  • @KairosGreece
    @KairosGreece 4 года назад

    works.

  • @adityapanwar5461
    @adityapanwar5461 4 года назад

    What about dates.

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

    Chhoo...iyaaaa

  • @Trevorwiththewrx
    @Trevorwiththewrx 4 года назад

    Get off youtube

  • @sermadmomin9600
    @sermadmomin9600 4 года назад

    Thanks

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

    thank you