HI, Please help me write a formula to sort the 10 lowest scores out of the last 20 games and either mark them or copy in the next col.
I can add and average the result.
The real and complete way to calculate HDCP is
5 or 6 games Lowest 1
7 or 8 games Lowest 2
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
(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)
- Click Advanced next to Quick Post button at the bottom right of the editor box.
- Scroll down until you see "Manage Attachments",
- Click the "Choose" button at the upper left (upload from your computer).
- Select your file, click "open", click "upload"
- Once the upload is completed the file name will appear below the input boxes in this window.
- Close the Attachment Manager window.
- Click "Submit Reply"
Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!
Ben Van Johnson
file does not copy in the input box ( I presume its here)
Named Ranges:
HandicapTable =Sheet1!$J$4:$L$7
Playdates =Sheet1!$B$13:INDEX(Sheet1!R:R,MAX(Sheet1!Q:Q)+12)
ScoreColumn =Sheet1!$H$12
ScoreTable =Sheet1!$D$13:$G$32
Sort scores in columns D = G smallest to largest in column O:
Calculate HDCP in P13:P32
Please Login or Register to view this content.
In H12, use:Please Login or Register to view this content.to pick the score column to use via radiobuttons.Please Login or Register to view this content.
Calculate the number of games to average or calc hdcp:
count of games: =MAX(A13:A32)Please Login or Register to view this content.
Cross-posted : https://www.mrexcel.com/forum/excel-...el-2007-a.html
Your post does not comply with Rule 8 of 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.
Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!
Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
It has been cross-posted elsewhere, too.
Denis - you must tell us everywhere else you have posted the same query.
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.
Thank You very Much ProtonLeah, It is much more than I expected, I'll study it and hope I can manage it thru the season for the small league.
Again Many thanks and sorry about the double posting
Denis
can you help complete these formulas?
I tried to improve the prog. but got stuck along the way
Thanks
Hi ProtonLeah,
I've posted a reply at the end of this thread with no result so I'am trying this here, hope this is not cross posting...
Can you improve the formulas included in the program included
I thank you very much
Debes7 - please see post #6. You will get no further help here until you comply. You have been warned - if you continue to ignore this request, there will be further consequences.
Hi AliGW,
Am I missing something here, I first posted a tread in the spring and innocently posted it somewhere else also wanting a fast answer.
So I apparently made a mistake as to your standards and I am sorry.
Now I come back and request some help again this time at the end of the tread where I think it's the right place and unfortunately get no response so
I copy the same message directly to my previous helper and I mention the move, What else do you want?
?????????
That's the only other place where I posted the same question and it was noticed and I said I was sorry.
Now What else?
OK no Links.... so it was On MrExcel.com
Dont know what to do any more, sorry
Thank you for including the other site where you x-posted this question.
I understand you cannot include links until you have at least 10 posts, but you could still paste the link here, just add a few spaces in the link, here and there.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I have now reinstated the posts to this thread. Thank you.
"00 excelguru.ca/ forums/ showthread. php?8908-to-sort-10-lowest-figures-out-of-20-using-excel-2007&p= 36628#post36628"
I had forgotten about this one "excelguru"
"00 mrexcel.com/ forum/ newreply.php?do=newreply&p= 5041728"
tried with many ways ,spaces 000 more spaces rem htt
There you go... now It works
Thank you.
What's the status of this thread? Post 8A(?) is still hidden... Still asking for help?
It’s there now - help can be offered. Not sure if it is still wanted, however.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks