+ Reply to Thread
Results 1 to 7 of 7

please, put the trio in ascending order .

  1. 01-20-2019, 06:50 AM #1
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    please, put the trio in ascending order .

    please, put the trio in ascending order
    I will always put new trios every week.
    * ex = 462 = 246
    https://www.excelforum.com/attachmen...1&d=1547981441
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-20-2019, 07:04 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,914

    Re: please, put the trio in ascending order .

    Simple formula solution - in E6 copied across and down:

    =SMALL($A6:$C6,COLUMNS($E:E))
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 01-20-2019, 07:15 AM #3
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: please, put the trio in ascending order .

    ok perfect, thank you!
    Reply With QuoteRegister To Reply
  4. 01-20-2019, 07:18 AM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,914

    Re: please, put the trio in ascending order .

    You're welcome!
    Reply With QuoteRegister To Reply
  5. 01-20-2019, 07:21 AM #5
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: please, put the trio in ascending order .

    ok! thank you
    Reply With QuoteRegister To Reply
  6. 01-20-2019, 04:16 PM #6
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: please, put the trio in ascending order .

    I can not copy, paste the formula, can you help me please
    Reply With QuoteRegister To Reply
  7. 01-20-2019, 04:41 PM #7
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,914

    Re: please, put the trio in ascending order .

    What do you mean? Put it into E6 then drag copy it across to G6 and down as far as you wish.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Ascending Order
    By isaackoh in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-26-2014, 10:59 AM
  2. Ascending Order
    By isaackoh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2014, 06:49 AM
  3. Ascending Order Output
    By fareen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-22-2013, 04:14 AM
  4. [SOLVED] Sort Ascending order
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-16-2013, 02:27 PM
  5. [SOLVED] Generate "ascending order no" for columns of data that are not in order
    By abreichenbach in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-20-2013, 02:22 AM
  6. ascending order
    By cbian in forum Excel General
    Replies: 2
    Last Post: 06-05-2008, 07:26 AM
  7. Ascending order and IF
    By kookinuttz in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-07-2007, 08:27 AM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1