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