multiple formuals in a cell

  • Thread starter Thread starter pinmaster
  • Start date Start date
P

pinmaster

This is a tough one, but here it goes!....in AO5:AO14 is my list of to
10 of people that changes every week depending on the results fro
AP5:AP14....here's the formula
=INDEX($A$5:$A$45,MATCH(LARGE($AB$5:$AB$45,ROW()-5+1),$AB$5:$AB$45,0))
in AP5:AP14 is the top 10 in points from AB5:AB45, here's the formula
=LARGE($AB$5:$AB$45,ROW()-5+1

After 26 weeks the people from AO5:AO14 will be locked in but th
points will change..... this is the formula that I want to use afte
week 26
=SUM(ACrow_number:ALrow_number)+5050 for 1st
 
First of all, I'm managing our local Nascar Pool if this will help!
Ok...lets say that this a the finishing order after 26 weeks o
racing!...on week 27 those in the top 10 in points will be locked-i
and start with new points for the remainder of the season.
This is the current formula for points for the first 26 weeks
=LARGE($AB$5:$AB$45,ROW()-5+1)
and this is how the points will calculated for the last 10 weeks fo
those in the top 10 in points
=SUM(ACrow_number:ALrow_number)+number_of_poins
depending on who's in the top 10 and where. Is there a way that thi
formula
=LARGE($AB$5:$AB$45,ROW()-5+1)
would change to this for the last 10 weeks
=SUM(ACrow_number:ALrow_number)+number_of_poins
the formula would also have to figure out who is the top 10, where an
their row #
Week Week
first 26 27
Driver points points
Earnhardt 185 5050 =SUM(AC11:AL11)+5050
Stewart 180 5045
Wimmer 170 5040
Harvick 165 5035
Johnson 160 5030
Nemechek 150 5025
Gordon, J 146 5020
Sadler 142 5015
Kenseth 138 5010
Jarrett 134 5005 =SUM(AC17:AL17)+5005

P.S. if it can't be done it is Ok, I can do it manually when the tim
comes!

Jean-Gu
 
Hi
one question: How do you identify that you have reached the last 10
weeks (is there a cell which stores the date). You may use a formula
like
=IF(cell_with_date<specific date,SUM(....),LARGE(....))
 
column AA5:AA45 is the 26th weeks and I figured that any values entere
there could be used to trigger the formula!...does this help
 
Oh man, I have no idea what to do with that. Maybe there's another way
what if I insert a column between week 26 and 27?...could you figur
out how to award those top 10 thes
points?...5050,5045,5040,5035,5030,5025,5020,5015,5010,5005
it wouldn't matter if those points are award before the 26th week
those top 10 would automatically show up after week 26, I think tha
would work best and a lot simpler!

Best regards
Jean-Gu
 
Hi
now I'm a little bit confused :-)
Try mailing me your spreadsheet (frank[fot]kabel[at]freenet[dot]de) and
I'll have a look at it
 
Back
Top