I am making a points spreadsheet for the local race track. I've figured
out how to assign points for each heat race based on starting position
and finishing position. Now what I need is a function to pull data from
the points earned in all three heats to assign drivers a starting
position in the feature race. The formula needs to be able to recognize
which driver coincides with which score (they're on the same row.) I
thought MATCH would work, but it returned errors. I might be using it
wrong. Any ideas?

~Jonathan


--
jonlandrum

http://jonlandrum.com/about/
------------------------------------------------------------------------
jonlandrum's Profile: http://www.excelforum.com/member.php...o&userid=33615
View this thread: http://www.excelforum.com/showthread...hreadid=533952

I forgot to mention that the formula has to give preferance to heat 1
over heat 2, and heat 2 over heat 3. So, if drivers in all three heat
races score 59 points, they will be lined up in the feature race
according to which heat they raced in. And, if there are two drivers in
the same heat that tie, the tie-breaker needs to be based on their
starting position. This is all probably not do-able, but I told them
I'd ask. Thank you guys for any help you can offer.

~Jonathan


--
jonlandrum

http://jonlandrum.com/about/
------------------------------------------------------------------------
jonlandrum's Profile: http://www.excelforum.com/member.php...o&userid=33615
View this thread: http://www.excelforum.com/showthread...hreadid=533952

Hi
How many heats in one day and is it OK to have a new sheet each day?

jonlandrum wrote:
I forgot to mention that the formula has to give preferance to heat 1
over heat 2, and heat 2 over heat 3. So, if drivers in all three heat
races score 59 points, they will be lined up in the feature race
according to which heat they raced in. And, if there are two drivers in
the same heat that tie, the tie-breaker needs to be based on their
starting position. This is all probably not do-able, but I told them
I'd ask. Thank you guys for any help you can offer.

~Jonathan


--
Please take a look at www.openoursite.com and you will see how I want to
use.

God Bless for helping

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200604/1

Three heats in one day; yes, it's perfectly okay to have a new sheet for
each day.


--
jonlandrum

http://jonlandrum.com/about/
------------------------------------------------------------------------
jonlandrum's Profile: http://www.excelforum.com/member.php...o&userid=33615
View this thread: http://www.excelforum.com/showthread...hreadid=533952

Oh yeah, and each class will have its own sheet, too. But that's pretty
much irrelevant.


--
jonlandrum

http://jonlandrum.com/about/
------------------------------------------------------------------------
jonlandrum's Profile: http://www.excelforum.com/member.php...o&userid=33615
View this thread: http://www.excelforum.com/showthread...hreadid=533952

Any ideas?


--
jonlandrum

http://jonlandrum.com/about/
------------------------------------------------------------------------
jonlandrum's Profile: http://www.excelforum.com/member.php...o&userid=33615
View this thread: http://www.excelforum.com/showthread...hreadid=533952

I think I was able to group the formulas for the three heat races by
highlighting the cell block and applying a name, but I don't know what
to do with it after this.


--
jonlandrum

http://jonlandrum.com/about/
------------------------------------------------------------------------
jonlandrum's Profile: http://www.excelforum.com/member.php...o&userid=33615
View this thread: http://www.excelforum.com/showthread...hreadid=533952

Sorry not here to help sooner. The way it sounds, you have your spreadsheet
set with drivers names across the top and heats down.

Just getting started in this application, it seems to me that it would be
better to have the drivers names down column "A".

Then the starting position & heats in the next columns, such as:
Column B = start position 1st heat
Column C = points earned 1st heat
Column D = start position 2nd heat
Column E = points earned 2nd heat
Column F = start position 3rd heat
Column G = points earned 3rd heat

Then in column E you could sum your points for each rider from columns C + E
+ G for a total.

I would then have column H blank

Then have a macro copy the names in column A to column I
Then have the same macro copy the point totals for drivers to column J (paste
values only)
Then have the same macro select the data in columns I & J and sort by column
J.

You now have drivers in order by points earned.

A second macro (when needed) could be run to place a count 1 thru ? next to
each drivers score in column K. This macro would first check to see if 1st
drivers scrore is equal to 2nd drivers score. . . . .

Here, I don't know how you want to make a decision on equal scores according
to what.

Does this sound interesting so far ???? Give me a post. I will help when I
can.




jonlandrum wrote:
I think I was able to group the formulas for the three heat races by
highlighting the cell block and applying a name, but I don't know what
to do with it after this.


--
Please take a look at www.openoursite.com and you will see how I want to
use.

God Bless for helping

Message posted via http://www.officekb.com