+ Reply to Thread
Results 1 to 3 of 3

convert in ascending order each pick 3 from the draw list .

  1. 09-23-2021, 09:25 AM #1
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    convert in ascending order each pick 3 from the draw list .

    convert in ascending order each pick 3 from the draw list ex= 694= convert to ascending= 469 ex= 484= 448 every week there will be new draws
    https://www.excelforum.com/attachmen...1&d=1632403519
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-23-2021, 09:38 AM #2
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: convert in ascending order each pick 3 from the draw list .

    Try at E7

    =SMALL($A7:$C7,COLUMNS($E7:E7))
    Attached Files Attached Files
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
  3. 09-23-2021, 09:50 AM #3
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: convert in ascending order each pick 3 from the draw list .

    ok BO_RY, corret, conglatulations, thank you!!
    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. List Unique Values Ascending Order
    By ptmuldoon in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-25-2020, 01:18 PM
  2. VB Code to sort the list in ascending order
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-22-2015, 12:08 PM
  3. [SOLVED] ascending order of a price list
    By kghisla in forum Excel General
    Replies: 7
    Last Post: 04-10-2014, 12:46 PM
  4. Create List in Ascending order and unique value
    By Arsalansansari in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2012, 02:34 PM
  5. [SOLVED] List Ascending Order shows duplicates
    By tomlancaster in forum Excel General
    Replies: 3
    Last Post: 04-05-2012, 06:10 PM
  6. Putting a List in Ascending Order and Skipping Duplicates
    By AamerP86 in forum Excel General
    Replies: 7
    Last Post: 09-10-2010, 03:25 PM
  7. eliminate repeat values from a list of ascending order
    By norumbegan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-14-2006, 09:05 PM

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