+ Reply to Thread
Results 1 to 9 of 9

Google Sheets: select the 4 best values out of 5 in a spreadsheet.

  1. 10-23-2021, 11:39 AM #1
    Noar33
    Noar33 is offline
    Registered User
    Join Date
    10-23-2021
    Location
    Montreal
    MS-Off Ver
    365
    Posts
    5

    Google Sheets: select the 4 best values out of 5 in a spreadsheet.

    Hi guys,

    I have a simple task to do.
    I have a series of 5 digits from 0 to 5 and, I am looking for a formula to select the four best grades and do the sum.
    For example, if I have 0, 2,2, 1, 3, I would like to keep 2,2,1,3 and add them .

    thanks in advance
    Reply With QuoteRegister To Reply
  2. 10-23-2021, 11:41 AM #2
    JEC.
    JEC. is offline
    Forum Expert
    Join Date
    10-11-2021
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    1,377

    Re: select the 4 best values out of 5 in a spreadsheet.

    Double post?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 10-23-2021, 11:51 AM #3
    Noar33
    Noar33 is offline
    Registered User
    Join Date
    10-23-2021
    Location
    Montreal
    MS-Off Ver
    365
    Posts
    5

    Re: select the 4 best values out of 5 in a spreadsheet.

    yes correct ! thank you so much for the quick reply
    Reply With QuoteRegister To Reply
  4. 10-23-2021, 12:18 PM #4
    Noar33
    Noar33 is offline
    Registered User
    Join Date
    10-23-2021
    Location
    Montreal
    MS-Off Ver
    365
    Posts
    5

    Re: select the 4 best values out of 5 in a spreadsheet.

    thanks again,
    I tried it but it only takes the larger digit not the 4 larger.
    See attached spreadsheet
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 10-23-2021, 12:35 PM #5
    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,460

    Re: select the 4 best values out of 5 in a spreadsheet.

    It works fine!

    AliGW on MS365 Insider (Windows) 32 bit
    A
    B
    C
    D
    E
    F
    G
    1
    		 hector
    0
    1
    2
    5
    3
    11
    2
    		 abib
    1
    3
    3
    3
    4
    13
    Sheet: grades

    Are you using MS365, as your profile says, or something older? You may have to enter the formula with CTRL+SHIFT+ENTER, if the latter.
    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
  6. 10-23-2021, 12:50 PM #6
    Noar33
    Noar33 is offline
    Registered User
    Join Date
    10-23-2021
    Location
    Montreal
    MS-Off Ver
    365
    Posts
    5

    Re: select the 4 best values out of 5 in a spreadsheet.

    thanks a lot !!!!!

    Numbers 11 and 13 in column G are corrects, this is exactly what I am expecting.
    Maybe I missed something in the formula, please see attached print screen
    Regarding, your question I am not sure to be honest as I am using the google docs version

    Thanks for your help
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  7. 10-23-2021, 12:58 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,460

    Re: select the 4 best values out of 5 in a spreadsheet.

    Administrative Note:

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As you are new, I will do it for you this time: https://www.mrexcel.com/board/thread...sheet.1185559/)
    Reply With QuoteRegister To Reply
  8. 10-23-2021, 12:59 PM #8
    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,460

    Re: Google Sheets: select the 4 best values out of 5 in a spreadsheet.

    I have moved this thread to the correct forum section.
    Reply With QuoteRegister To Reply
  9. 11-07-2021, 09:22 AM #9
    veyselemre
    veyselemre is offline
    Registered User
    Join Date
    04-07-2019
    Location
    Turkey-Ankara-Çubuk
    MS-Off Ver
    Office 2010
    Posts
    51

    Re: Google Sheets: select the 4 best values out of 5 in a spreadsheet.

    Hi, try.
    Please Login or Register  to view this content.
    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. Google Sheets: How to have values appear from one tab but skip rows as needed.
    By yourik in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 10
    Last Post: 06-30-2020, 02:03 PM
  2. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  3. Google sheets: Send emails with a click of a button when spreadsheet is updated
    By rayted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 08-07-2018, 09:31 AM
  4. Importing Macro enabled spreadsheet into Google sheets and maintaining all properties
    By ChrisCD in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 09-14-2016, 09:36 PM
  5. Importing Macro enabled spreadsheet into Google sheets and maintaining all properties
    By ChrisCD in forum Excel General
    Replies: 0
    Last Post: 09-14-2016, 09:36 PM
  6. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 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