I'm creating a Score Caluculator for a Speech and Debate Competition. I'm only working on the first two tabs HS Debate English and HSDE Results. On the results page i have it calculate the scores from the first tab. Then it sums the rounds in the Total column. I want to evaluate the scores and have the 1st-7th place team names display by the 1st-7th cells. Any Help?
This might be of help. There are some hidden columns that I added with calculations in them.
Last edited by newdoverman; 02-06-2014 at 02:35 PM.
<---------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
Hi,
Here's an other proposal with an array formula in case you have 2 team with the same score...
(Array formula must be validated with CTRL + SHIFT + ENTER)
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
Thank you.
Thanks you guys are awesome!
here i was working on a slightly different version, attached anyway since i already did it.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Thank you for the feedback. As you have found out, there is more than one way of doing this.
Yes, Newdoverman plenty of ways to complete. Now I just need to figure out the Speech section. Thank you.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks