+ Reply to Thread
Results 1 to 14 of 14

Picking out the highest 4 of a selection on a row

  1. #1
    Registered User
    Join Date
    06-22-2012
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    8

    Picking out the highest 4 of a selection on a row

    I have a spreadsheet set up with rows of values, I want to be able to get excel to pick out the highest four values from a selection of columns within the row and give them a sum total.

    How??

    Please help!


    Amie

  2. #2
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,071

    Re: Picking out the highest 4 of a selection on a row

    Use the below assuming your data is in the range A1:A100

    Please Login or Register  to view this content.
    Show your appreciation - Click on the star icon if this post has been helpful

  3. #3
    Registered User
    Join Date
    06-22-2012
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Picking out the highest 4 of a selection on a row

    That covers a range down a column, I need it across a row. Is that not possible?


  4. #4
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,071

    Re: Picking out the highest 4 of a selection on a row

    Try this ..the row range is A:P

    Please Login or Register  to view this content.
    Show your appreciation - Click on the star icon if this post has been helpful

  5. #5
    Registered User
    Join Date
    06-22-2012
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Picking out the highest 4 of a selection on a row

    Oh, and I forgot to add that the colunms I want it to pick from are not adjacent to each other.

    I am probably wanting to do something thats not possible!

    Thanks again

  6. #6
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,071

    Re: Picking out the highest 4 of a selection on a row

    How about this...?
    Columns A,B,Q,AA,AD hold the data

    Please Login or Register  to view this content.
    Show your appreciation - Click on the star icon if this post has been helpful

  7. #7
    Registered User
    Join Date
    06-22-2012
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Picking out the highest 4 of a selection on a row

    not sure I have explained it very well, I want it to sum the top four values from row 5 columns c,d,e,f,h,l,p,q
    Then in a different cell I want to repeat the formula for columns g,i,j,k,m,n,o,r

    Does that make it clearer?
    Thank you

  8. #8
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,071

    Re: Picking out the highest 4 of a selection on a row

    Replace columns in Post#6 with desired ones to achieve the results

    Show your appreciation - Click on the star icon if this post has been helpful

  9. #9
    Registered User
    Join Date
    06-22-2012
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Picking out the highest 4 of a selection on a row

    ah wrote my reply at the same time, will give that a go

  10. #10
    Registered User
    Join Date
    06-22-2012
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Picking out the highest 4 of a selection on a row

    Fantastic - works a dream!

    Thank you sooooooo much :D

    Amie

  11. #11
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,071

    Re: Picking out the highest 4 of a selection on a row

    Glad it did ..please mark the thraed as 'Solved'. Enjoy the forum!

  12. #12
    Registered User
    Join Date
    06-22-2012
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Picking out the highest 4 of a selection on a row

    How do I do that??? :s

    New to this forum! lol

  13. #13
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,071

    Re: Picking out the highest 4 of a selection on a row

    Welcome again!

    here's how..
    Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

    http://www.excelforum.com/forum-rule...rum-rules.html

  14. #14
    Registered User
    Join Date
    06-22-2012
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Picking out the highest 4 of a selection on a row

    Cheers, and done.

    Back to the work book now

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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