LinkBack URL
About LinkBacks
Hello everyone, just joined the fourm and excel is relatively new to me.
I was hoping someone could help me, I am wanting to find a formula to calculate the best 5 scores from 6 results.
Hello everyone, just joined the fourm and excel is relatively new to me.
I was hoping someone could help me, I am wanting to find a formula to calculate the best 5 scores from 6 results.
Not real clear.
Post some sample data and show us what results you expect.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Agree with Tony, but on the off-chance that you mean you have 6 values, and you want the highest 5, try this....
B1=IF(ROW(A1)>5,"",LARGE($A$1:$A$6,ROW(A1))) copied down
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
1) See the Rank function in Column C
2) Column B highlights the highest 5 scores from the list. (conditional formatting)
Sorry guys, this is what I am looking my sheet to do ....
A
1. 5
2. 2
3. 4
4. 5
5. 4
6. 5
Total. 23
The lowest number was dropped and the rest totaled to give a best five round score of 23
Sent from my Nexus 7 using Tapatalk
Assuming there is always 6 numbers...
Try one of these:
=SUM(A1:A6)-MIN(A1:A6)
=SUM(LARGE(A1:A6,{1,2,3,4,5}))
If the 6 scores are in B2:B7 select a range of 5 cells in a column where you want the 5 best scores and enter this formula with Ctrl + Shift + Enter (array formula)
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Guys I have the formula counting on their own (I have two going at the same time) one is counting the number of fish caught by an angler and the column next to it is counting the length of the fish for each round (there is six altogether), for some reason the total fish column and the total length column are both picking up the numbers entered in both columns????
Try this...
If you are wanting to sum the 6 largest values (b2:b7) then this will do it (enter with Ctrl + Shift + Enter):
Formula:Please Login or Register to view this content.
Cheers for that xx7 that's what I am looking for only I want the best five results from the six roundsOriginally Posted by Xx7
Cheers Newdoverman I am looking to go across the spread sheet tho :-)
Just a normal Enter will do. No need to CSE that formula.
I'm not following you on this.
Can you post a SMALL sample file that demonstrates what you want to do? 20 rows worth of data is plenty. Make sure you show us what results you expect.
@ Tony Valko
Correct...thanks
------
If you are wanting to copy across columns with the totals for each column change the B to whatever column you are starting in:
Formula:Please Login or Register to view this content.
Tony my sincerest apologies, I made a schoolboy error your formula works a treat :-) thanks for your patience :-)
Sent from my Nexus 7 using Tapatalk
Good deal. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks