High Scores And Tiebreaker

Oct 1, 2009

This is for a forestry contest. Students compete in 6 different categories (columns B through G). Teams can have up to four members and the top three member scores are taken to determine a team score. Teams are then ranked. Here is where I need help. I would like to be able to find the high individual score for each category in the contest. (sawlog, pulpwood, tree ID, etc) If there is a tie in the category it is broken using the category in the column to the right. Example – sawlog 1st tie breaker is pulpwood, the 2nd tiebreaker is thinning. The last column, Compass, uses sawlog as 1st tie breaker and pulpwood as 2nd tiebreaker.

Example
Will on the RHS team had a score of 112 in Tree ID and a score of 48 in thinning.
Michael on the WHS team also had a 112 score in Tree ID and a score of 44 in Thinning.

So Will is the high individual in that event –

How can I create a formula that will bring the winners name down to row 66-71 and also bring the score down to row 66-71 to show who won each event? example spreadsheet attached.

View 3 Replies


ADVERTISEMENT

Find The High Price Day Of Each Week. Then Report The Median High Day

Aug 14, 2008

I have an interesting problem (I hope you find it interesting too). I'm trying to find the historical "high" day of the week for a particular stock I follow. I searched for several hours but was honestly unable to make any progress. Normally I do my own formulas, so other than pasting a rare macro, that's pretty much the extent of my (lack of) experience, ie please assume I am a novice....

View 9 Replies View Related

Find Top X Scores Out Of 50 Scores?

Aug 17, 2009

There are scores in B1:B10 (10 scores). I want to take the top 8 scores. So I used this formula which works just fine.

=SUM(LARGE(B1:B10,1),LARGE(B1:B10,2),LARGE(B1:B10,3),LARGE(B1:B10,4),LARGE(B1:B10,5),LARGE(B1:B10,6) ,LARGE(B1:B10,7),LARGE(B1:B10,8))

But I'm trying to make the formula a bit more dynamic. Is there anyway to have a set of data in B1:B50 (50 scores will probably be the most) and take the top x scores? X will be set in a separate cell (lets just say A1)?

View 5 Replies View Related

Map Scores To Scaled Scores

Feb 13, 2008

I have a raw score for each case. I need to map those raw scores to scale scores. For example, a raw score of 0 to 0.49 maps to a scale score of 120, a raw score of 0.5 to 0.99 maps to a scaled score of 110, etc. There are a total of 13 possible scaled scores (120, 110, 100, ... 20, 10, 0). Is there a way to do this in Excel2003? (Note, if anyone on the list is 'bilingual' (Excel and SPSS), I'm looking for the Excel equivalent of the SPSS command RECODE raw (lo thur .49=120), (.5 thru .99=110), etc. INTO scale.

View 2 Replies View Related

52 Day High/low

Mar 4, 2007

I am trying to calculate the 52 day high/low for a stock in excel.

View 9 Replies View Related

Sort High To Low

Mar 28, 2009

I have the following table...

NameQuestions correctQuestions WrongENTERPositionNameQuestions correctQuestions WrongPoints1dave6216203ben531240506jan712070809dan802410011fred44812tom354

When the data is typed into the top box, I have a macro for the "enter" button that places the data into row 12.

What I really need is after the data is placed into row 12, is for the table to be sorted highest points to lowest points, and if scores are the same then in alphabetical order.

This is my macro......

Sub Results()
Range("C9:E9").Select
Range("E9").Activate
Selection.Copy
Range("C23").Select
ActiveSheet.Paste
Range("C9:E9").Select
Range("E9").Activate
Application.CutCopyMode = False
Selection.ClearContents
End Sub

View 9 Replies View Related

Low And High Numbers With Stats

Jun 6, 2009

I seem to find myself stuff on this project yet again, JBeaucaire was able to help me to get this far im hoping you will be able to help me with the next step of this project
The doc iv attached is able to give me the differnece between low and high numbers with this example low numbers being between 1-18 and 19 – 36 high numbers and 0 being a break if u test the project u will understand im now trying to create a pattern of 3s were im abe to get stat hits on for example the patterns of 3s are the following(numbers) low,low,low-low,low,high-low,high,high-low,high,low every time I type in the numbers 3 times in a row on the 3rd one I want it to show as a hit(success) if the 3 numbers I type in are not a hit like high,high,high I want it to show me a miss if it is a pattern I want it to show a if theres a 0 it must rest like from 0miss,4hits,o breaks to 0miss,0hits,1break and so forth im also wondering if at another part of the form it can keep the total stats like iv added In the doc

View 14 Replies View Related

Sort The Addresses From Low To High

Jan 4, 2008

I have voter registration pdf where I can open the table of info into excel when I can edit it. When I try to sort the addresses from low to high. example I have 3 main st, 20 main st, 78 main st, 300 main st. When I try to use sort to arrange them from low to high it does not work correctly do you think I am having a problem when adobe opens it to excel or am I doing something wrong?

View 9 Replies View Related

Conditional Format For Low, Mid & High

Jun 13, 2007

Sorry I don't mean to bring up old post of mine but my boss wanted me to change how this works. I have placed a link to the old post of mine in hopes that it may help. Instead of having two conditions that turn green, he wanted to combine those two, have the lower turn red and the higher turn yellow. Still only three colors but I am unfamilar with how these conditional formats work.

View 9 Replies View Related

Find Intermittent High Value

Jul 8, 2007

I am analysing market data to determine when trades should take place and when they should be closed. This works well. But I need to find the intermittent high value between the dates for purchase and the closing trades, and then insert these values in column S in the attached worksheet.

I don't know if a function can find these values or if a macro is needed (or if I should amend the existing macro that currently finds the
closing trades).

This macro is included in the attached spreadsheet. It Is:


....

View 9 Replies View Related

Rows High For Only Cells That Have Some Data

Jul 31, 2014

I need a VBA code to adjust Rows high for only the cell has data in it.

View 4 Replies View Related

Picks Up The Drifferences Between Low And High Numbers

Jun 5, 2009

picks up the drifferences between low and high numbers for example 1-10 is low 11-29 high and 0 is a alternate so say i start typing in 1,2,3,11,15 in the top cell they start decending down the rows automtically and the program has 2 boxs indicating 3 lows and 2 highs and wen i type in a 0 it resets the two boxs to 0

View 5 Replies View Related

High Frequency Data Calculation

Oct 16, 2009

Suppose you have a large database, which consists of high frequency minutes data, you need to calculate differences in values between each different time intervals, e.g. from 1 min to 10000 mins.

the format is looked like below

1 min aaa
2 min bbb
3 min ccc
4 min ddd
.................
......................


More specifically, what I am supposed to do is to calculate aaa-bbb, bbb-ccc, ccc-ddd, and then aaa-ccc, bbb-ddd, and then aaa-ddd and so on.

I know the VBA has a function to do repeated executions but am not sure how to adjust the time intervals.

View 9 Replies View Related

Add High / Low Points To Line Chart?

Aug 23, 2013

How to add high/low points to a line graph, similar to what sparklines have. The file I am using now doesn't allow me to add new columns of data, so I'm trying to figure something out that just updates dynamically using the data I already have in place.

This page has the thing I want to do, but it requires additional columns to be added to work, which I don't want:

Excel - Show High/Low Points on a Line Chart

View 2 Replies View Related

Chart: Plot High And Low Data Only

Aug 12, 2008

I have a 46000 rows of data. I want to make a chart, but only want to plot the highest and lowest data points in the data set. How do I get Excel to automatically find and plot only the highest and lowest data points?

View 9 Replies View Related

Weighted Average Excluding High/Low

Jan 6, 2009

I'm trying to calculate a weighted average excluding the top and bottom value, and am having trouble creating a formula that can be dragged across.

my values are in E2:L17, and the weights are in M2:M17. Basically I want a weighted average of each column, using M2:M17 as the weights.

I'm sure someone's done something like this before, care to assist?

Example:

Data: 1, 2, 3, 4, 5
Weights: 3, 4, 5, 6, 7

Weighted avg ex hi/lo: (2x4+3x4+4x6)/3 = 44/3

View 9 Replies View Related

Lookup Number Between High/Low Range

Aug 25, 2006

I have two columns of numbers (I'm going to call them Column A & Column B). There are 23 rows with these numbers. There is another column (Column C) which is also 23 rows of numbers. I am trying to find a way for a designated cell that falls between the two numbers in Column A and Column B to display the number in Column C. The numbers would work their way across the row. For example, if cell A1 had a value of 1 and B2 had a value of 10 and cell c3 had a value of .034, if the designated cell has a value of 7, I would want the cell below the designated cell to show the value of .034. I can't use the if/then function because of the 7 limit. I also can't use the vlookup because there is a range of numbers instead of an equal to.

View 4 Replies View Related

Find & Return Weekly High Value

Aug 14, 2008

I want to find the high value from daily data for each week and copy that value.

I have a list of daily price data, being the date, opening price, high price, low price and closing price. For each week I am finding the data necessary to create a list of the weekly opening price, high price, low price and closing price ending on each Friday.

To find the opening price I am using this formulae -
=INDIRECT(ADDRESS(MATCH(J2,$A$1:$A$1400,0)+1,COLUMN(B1)))

To find the closing price the formulae is -
=INDIRECT(ADDRESS(MATCH($J$3,$A$1:$A$1400,0),COLUMN(E2)))

I need to find the high value and the low value within the five days data, from two separate columns (C and D) of daily data.

Can I use a formula similar to those above, but instead of copying a relevant cell, for example, finding the high from cells B3 to B7. Then I need to do this for each subsequent week.

An example spreadsheet is attached. You will see that currently I am currently copying the Friday data in columns L and M as I don't know how to adapt the formula to do the job.

View 9 Replies View Related

Calculate Weighted Averages Using High, Medium, Low

Dec 31, 2008

On another thread I found a solution to creating a weighted average given a pair of columns of numbers but I have column B consisting of values given as High, Medium and Low and the weighted column C of 1, 2 or 3.

How can I use the formula below to accomplish this, or is this maybe not the right way to created a weighted average?

=SUMPRODUCT(B2:B11,C2:C11)

View 7 Replies View Related

Finding Lowest Percentage From Peak High To Low?

Aug 30, 2013

I had the following:

0.000%

-2.140%

-1.729%

0.973%

1.206%

1.469%

[code]...

I want to know the lowest number from the peak high to the lowest low was? If I have not explained that properly, if I had 12.00% as the highest and the next few rows consistently, and gradually moved to a low of 8.00% that would be a difference of -4.00%. So -4.00% would be my answer. formula as I need to know this one number in a column of 4000+ percentages like you see above.

View 9 Replies View Related

High Score Table To Update Automatically

May 17, 2006

I've written a Fantasy Football programme, which is 100% working, however I would like to have the highscoe table update automatically, rather than using the data/sort command. E-mail me and I'll sent it to you with what I'm trying to do.

View 2 Replies View Related

Return State Value Based On Match Of Name And Number Between High And Low

Aug 27, 2013

I have a set of data (Data tab) that lists name, a high number, a low number, and the state that is associated with the name and range between the high and low number (see attachment). I am trying to figure out a formula that will return the state value based on a match of the name and the number between the high and low. I am trying to use Index/Match but i cant figure out the "between the high and low" portion.

tester.xlsx

View 2 Replies View Related

Track High Price Of Stock From Date Of Purchase?

Dec 5, 2013

Any cleanest way to track the high-water mark of the price of a stock I own ONLY AFTER my date of purchase.

Each day I log on, a VLookup pulls up the recent stock price. How can I create a formula that will store this price and compare it to the stock price the next time I log in and save the highest of the two prices for the next day's comparison.

Day 1 $10
Day 2 $11- The $10 is replaced by $11
Day 3 $10- The $11 is retained.
Day 4 $12- The $11 is replaced by $12.

View 3 Replies View Related

Exporting (Saving) Text Box As High Quality Image?

Jul 4, 2012

I need a macro that will export a text box as a high quality image, preferably .png. The code below copies and pastes the text box to a chart sheet and exports it as a .png, but the image quality is very low - under 100 dpi. Is there any way to export the image with high quality?

Code:
Sub createtextimage()
' Adding text to textbox
Dim q As String

[Code]....

View 1 Replies View Related

Plotting High Low Range Lines On Column Chart

Dec 18, 2013

I am trying to generate a column chart with a high-low range overlay so that it looks like error bars. I've precalculated all values but cannot figure out how to add the high-low range lines. The ranges are in the min and max columns.

I tried using custom error bars but it did not work.

View 4 Replies View Related

Auto Sorting Column From High To Low As Data Is Changed?

Jan 15, 2014

in excel where you can select a column and sort it from high to low, how can you get this to be done automaticly as the data changes?

View 2 Replies View Related

Top 5 Scores

Jul 7, 2009

Is it possible to make a top 5 scores section?

Ive been reading up on Arrays and how to use Arrays etc so i believe that it could be done with an array but i could be complete wrong.

what i have is players names in A4 and there averages in H4. i have 22 players listed but i want to take the top 5 scores from h4 and display them in a different section with there as so: NAME(A4): AVERAGE(h4) repeated 5 times and updates Automatically.

View 12 Replies View Related

Creating Multiple Named Ranges X Rows High X Columns Wide

Mar 13, 2012

I need to create hundreds of named ranges going down a single sheet.

The name of the first range is in cell a1 and is 13 columns wide and 7 columns high (a1:m7)

The next name is in a8 and the range is a8:m14 and so fourth

If it's easier on a separate sheet I can have a list of names I want in column A and then the cells they refer to in column B.

E.g.

A B

Range1 Sheet1!A1:M7
Range2 Sheet1!A8:M14
Range3 Sheet1!A15:M21

View 2 Replies View Related

Look Up Highest Scores

May 9, 2007

What is the best way to look up and return the 10 best performers out of a list of say, 40. I have columns representing people's names, their school's name, their age and their total score. The following formula is to add up the 4 highest scores for each school: SUM(LARGE(($A$2:$A$499=Y2)*($C$2:$C$499),{1,2,3,4})) (entered as an array) Now I want to display the 10 best performing schools (who will be determined by calculating their 4 best scores).

View 4 Replies View Related

Placing Value On Bottom 3 Scores

Mar 3, 2014

I am trying to do the following:

901 > 0 pts
851 - 900 gets 1 pts
LOWEST 3 scores gets 2 pts

Example of what i have for the top three
=IF(D8="-",0,IF(RANK(D8,D$8:D$34)<=3,2,IF(D8<79%,0,1)))

I have tried to change it but cant get it to work for the bottom 3 scores.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved