+ Reply to Thread
Results 1 to 7 of 7

Google Spreadsheet-Sorting 24 numbers in ascending order to specific cells

  1. #1
    Registered User
    Join Date
    09-18-2021
    Location
    Sweden
    MS-Off Ver
    Google Spreadsheets/2010
    Posts
    59

    Question Google Spreadsheet-Sorting 24 numbers in ascending order to specific cells

    samma värde.png


    In D2:F9 i want numbers starts at 1 and up to 24
    Number 1 i match the highest number in A2:C9

    All of the numbers that is in column A goes into column D
    Numbers at B goes into E
    C goes into F in the same row

    Starting with the highest number in A2:C9, that is in C4 (73), that number is 1 and goes into F4
    The second highest is in A3(64) and goes into D3 as number 2 and so on up to 24

    Im not sure if its same value in the green, what to do yet

  2. #2
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,490

    Re: Google Spreadsheet-Sorting 24 numbers in ascending order to specific cells

    With D2 the active cell,
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-18-2021
    Location
    Sweden
    MS-Off Ver
    Google Spreadsheets/2010
    Posts
    59

    Re: Google Spreadsheet-Sorting 24 numbers in ascending order to specific cells

    Works perfect. So easy formula if i just knew it, i tried alot of other fomulas, haha. Thank you very much!

  4. #4
    Registered User
    Join Date
    09-18-2021
    Location
    Sweden
    MS-Off Ver
    Google Spreadsheets/2010
    Posts
    59

    Re: Google Spreadsheet-Sorting 24 numbers in ascending order to specific cells

    And not to do same with hundreds of row below, whats the best way to have it filled in automatic? appscript?

    automaticFill.png
    Last edited by KentaTippar; 05-03-2022 at 04:53 AM.

  5. #5
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Google Spreadsheet-Sorting 24 numbers in ascending order to specific cells

    If the grid has a column containing an indicator value in each row to differentiate each group of 8 rows, then this could be done with a few formulas.

    For example, if the sheet is named '1X2', and the indicators are in column L (see screenshot example),
    Screen Shot 2022-05-03 at 10.55.48 pm.png

    then we can start by adding in a helper sheet that will be used to do all the dirty work.

    Lets call the helper sheet '1X2-Col-Rank'

    In the helper sheet, enter the following formulas...

    cell A1 (we create a pair of columns that has the ID and the items, in a straight list):
    Please Login or Register  to view this content.
    cell C1 (we rank each item within its ID group):
    Please Login or Register  to view this content.
    cell D1 (we convert the column of ranks into a grid):
    Please Login or Register  to view this content.
    Screen Shot 2022-05-03 at 10.57.33 pm.png

    now back on the original '1X2' sheet, delete the existing text from the header cells P1:R1

    then enter this formula into cell P1:
    Please Login or Register  to view this content.
    final result:
    Screen Shot 2022-05-03 at 10.58.48 pm.png
    Last edited by janmorris; 05-03-2022 at 12:04 PM.
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

  6. #6
    Registered User
    Join Date
    09-18-2021
    Location
    Sweden
    MS-Off Ver
    Google Spreadsheets/2010
    Posts
    59

    Thumbs up Re: Google Spreadsheet-Sorting 24 numbers in ascending order to specific cells

    Not working for me, must have missed something. Thank you janmorris :-)
    Last edited by KentaTippar; 05-03-2022 at 04:44 PM. Reason: working,wrong name

  7. #7
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,490

    Re: Google Spreadsheet-Sorting 24 numbers in ascending order to specific cells

    You may need to replace the \ with , in array constants, and the ; with , in function argument lists.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sorting Numbers as a Text in Ascending Order
    By T.I. in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-30-2021, 01:59 AM
  2. [SOLVED] Sorting lists of numbers in pairs and in ascending order
    By Lekan17 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-03-2020, 11:29 AM
  3. Replies: 4
    Last Post: 03-17-2017, 12:05 PM
  4. [SOLVED] Sorting a range in ascending order in a spreadsheet containing headings multiple rows
    By vbabeginnerjae in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-03-2012, 07:16 AM
  5. sorting numbers into ascending order
    By stevy123 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-03-2012, 08:00 AM
  6. Sorting Numbers in Ascending or Descending Order
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-28-2005, 11:25 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1