Results 1 to 3 of 3

Thread: Automatic Sort Number From Small

  1. #1
    Board Regular muhammad susanto's Avatar
    Join Date
    Jan 2013
    Location
    KPKNL Pekanbaru, Riau
    Posts
    1,494
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Automatic Sort Number From Small

    hi all..

    how to make sort from small number :

    col.a col.b col.c
    7 12 3

    my expected (sorted)
    3
    7
    12

    any help much appreciated..

    .sst
    Last edited by muhammad susanto; Aug 16th, 2019 at 11:25 AM.
    Sembunyikan & rahasiakan amal kebaikan kita sebagaimana kita mahir dalam menyembunyikan aib-aib kita

    Play in Ms Excel 2007 & 2013 on Win 7 32 Bit

  2. #2
    Board Regular Snakehips's Avatar
    Join Date
    May 2009
    Location
    Coventry UK
    Posts
    4,671
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Automatic Sort Number From Small

    Maybe along these lines....Excel 2010
    ABCDEF
    171232
    2
    3
    42
    53
    67
    712
    8

    Sheet1



    Worksheet Formulas
    CellFormula
    A4=IFERROR(SMALL($A$1:$F$1,ROWS(A$4:A4)),"")



    Hope that helps.
    Tony

    AbUsing Excel 2002 to 2013
    This line will be updated just as soon as I come up with something, original, witty, profound or interesting. Please don't hold your breath!

    Please remember - we cannot see your workbook nor read your mind.
    Help us to help you, post clear detail of what you have and what you want - from the start.

    A screen shot can save a thousand words!
    Post a screen shot with one of these: Excel Jeanie, MrExcel HTML Maker
    If posting VBA code, please use Code Tags - see: here

  3. #3
    Board Regular muhammad susanto's Avatar
    Join Date
    Jan 2013
    Location
    KPKNL Pekanbaru, Riau
    Posts
    1,494
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Automatic Sort Number From Small

    hi Tony, thank you very much...Perfecto!!
    Sembunyikan & rahasiakan amal kebaikan kita sebagaimana kita mahir dalam menyembunyikan aib-aib kita

    Play in Ms Excel 2007 & 2013 on Win 7 32 Bit

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •