Page 1 of 2 1 2 LastLast
Results 1 to 10 of 14

Thread: to sort 10 lowest figures out of 20 using excel 2007

  1. #1
    Seeker debes7's Avatar
    Join Date
    Apr 2018
    Location
    Longueuil, QC Canada
    Posts
    12
    Articles
    0
    Excel Version
    2007

    to sort 10 lowest figures out of 20 using excel 2007



    Register for a FREE account, and/
    or Log in to avoid these ads!

    HI, Please help me write a formula
    to sort the 10 lowest scores out of the last 20 entered by date and either mark them or copy in the next col. So they can be added.

    I can add and average the result.

    The real and complete way to calculate HDCP is
    5 or 6 games, sort the Lowest 1
    7 or 8 games, sort the Lowest 2 and so forth,
    9 or 10 Lowest 3
    11 or 12 Lowest 4
    13 or 14 Lowest 5
    15 or 16 Lowest 6
    17 Lowest 7
    18 Lowest 8
    19 Lowest 9
    20 games Lowest 10

    But if that's too complicated, I can live with 10 best of 20.
    Thanks

  2. #2
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,680
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Hi and welcome
    please post a small sample sheet with some data and expected results ( Click "Go advanced - Manage attachments). Thx
    Thank you Ken for this secure forum.

  3. #3
    Seeker debes7's Avatar
    Join Date
    Apr 2018
    Location
    Longueuil, QC Canada
    Posts
    12
    Articles
    0
    Excel Version
    2007

    Sort smallest entries Max(10) out of last date entered 20 items

    Sort col I to results in col K
    Attached Files Attached Files

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,290
    Articles
    0
    Excel Version
    Office 365 Subscription
    I am not sure I understand. You have six results and have picked out the lowest four - that's different to what you seem to be saying above. However, try this as a starting point in K13 copied down:

    =IF(I13<SMALL($I$13:$I$18,5),I13,"")
    Ali
    Enthusiastic self-taught user of MS Excel!

  5. #5
    Seeker debes7's Avatar
    Join Date
    Apr 2018
    Location
    Longueuil, QC Canada
    Posts
    12
    Articles
    0
    Excel Version
    2007
    Quote Originally Posted by AliGW View Post
    I am not sure I understand. You have six results and have picked out the lowest four - that's different to what you seem to be saying above. However, try this as a starting point in K13 copied down:

    =IF(I13<SMALL($I$13:$I$18,5),I13,"")
    Sorry about that, there should be only one result in K17 picked as 1 in 6 entries, that was a manual test sheet and forgot to remove the extras.
    Can you elaborate the formular to include the balance of the instructions up to:

    After more than 20 entries
    The last 10 more recent (date entries) out of the total should be picked
    thank you very much
    Denis

  6. #6
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,290
    Articles
    0
    Excel Version
    Office 365 Subscription
    Your post does not comply with our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    This query has been posted on at lease three forums with no links.
    Ali
    Enthusiastic self-taught user of MS Excel!

  7. #7
    Seeker debes7's Avatar
    Join Date
    Apr 2018
    Location
    Longueuil, QC Canada
    Posts
    12
    Articles
    0
    Excel Version
    2007

    Improve formulas and HELP

    Hi, I'am back, dont know where every replies went but that's not important, I presume it was not bringing any knowledge to anyone.
    Now, I've done some work since and came to (my insert) this and I'am stuck and need help.
    I tried to make the notes as explanatory as possible but it gets confusing to say the least.
    Please read the notes at the bottom, It may save some time if the suggestions are possible.
    I'am open for suggestions
    Thanks
    Attached Files Attached Files

  8. #8
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,290
    Articles
    0
    Excel Version
    Office 365 Subscription
    They are probably on the other forums where you posted the same query. Nothing has been deleted from here.

    We require you to post links here to all other forums where you have asked the same question before any help can be offered. Thanks for your cooperation.
    Ali
    Enthusiastic self-taught user of MS Excel!

  9. #9
    Seeker debes7's Avatar
    Join Date
    Apr 2018
    Location
    Longueuil, QC Canada
    Posts
    12
    Articles
    0
    Excel Version
    2007
    Quote Originally Posted by AliGW View Post
    They are probably on the other forums where you posted the same query. Nothing has been deleted from here.

    We require you to post links here to all other forums where you have asked the same question before any help can be offered. Thanks for your cooperation.

    I learned my lesson the first time and I assure you I didn't post any where else this time.

  10. #10
    Seeker debes7's Avatar
    Join Date
    Apr 2018
    Location
    Longueuil, QC Canada
    Posts
    12
    Articles
    0
    Excel Version
    2007
    Hi AliGW,
    I presume this is what you mean by posting again to the original thread to bump it.
    So there it goes,
    Can someone help me with my form, it requires many formulas that I can not formulate
    https://www.excelguru.ca/forums/show...l-2007&p=39788
    (attached file 3 boxes above)

    Please read the bottom suggestion before anything else it may simplify things.
    I am at your service to answer any questions
    Thanks a lot

Page 1 of 2 1 2 LastLast

Posting Permissions

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