Hello
I have excel documents with league tables in them.
At the end of the table i have a column that automatically shows where they are at the time.
It is all working great apart from one aspect.
At the top of the league i have, "CHAMP", "AUTO", "PLAY OFF"
So it will automatically show up when they are definitely in that area, but i cannot get "PLAY OFF" to show while in the top 2 places.
All we have to concentrate on is the top two formulas in the last column AK6 & AK7.
As you can see, in AK8 there is this formula: "=IF(OR(AND(S8>MAX(AJ$12:AJ$29),S8<MIN(AJ$6:AJ$7)),AND(SUM(AC8:AD8)=0, NOT(OR(AND(S8=S7,SUM(AC7:AD7)>0),AND(S9=S8,SUM(AC8:AD8)>0))))),"PLAYOFF")" which works perfectly.
In AK7 & AK6 it will automatically show when they are either "Auto" or "Champs", but i want it to also show that they are "Play Off" before they get to that stage, it looks wrong that 3rd place has "Play Off", but the other two do not.
In AK7 the formula is: "=IF(OR(AND(S7>MAX(AJ8:AJ29),S7<AJ6),AND(AND(S6=S7,SUM(AC6:AD7)=0),AND(S7=S8,SUM(AC7:AD8)=0))),"AUTO")"
In AK6 the formula is: "=IF(S6>MAX(AJ8:AJ29),IF(OR(S6>MAX(AJ7:AJ29),AND(S6=S6,SUM(AC6:AD7)=0)),"CHAMP","AUTO"))"
In effect i want...
AK7 to show "PLAY OFF" before it shows "AUTO"
AK6 To Show "PLAY OFF" before it shows "AUTO" before it shows "CHAMP"
Hopefully this is okay and you understand, if not i will try the upload document.
Thanks for looking
Regards
I have excel documents with league tables in them.
At the end of the table i have a column that automatically shows where they are at the time.
It is all working great apart from one aspect.
At the top of the league i have, "CHAMP", "AUTO", "PLAY OFF"
So it will automatically show up when they are definitely in that area, but i cannot get "PLAY OFF" to show while in the top 2 places.
All we have to concentrate on is the top two formulas in the last column AK6 & AK7.
As you can see, in AK8 there is this formula: "=IF(OR(AND(S8>MAX(AJ$12:AJ$29),S8<MIN(AJ$6:AJ$7)),AND(SUM(AC8:AD8)=0, NOT(OR(AND(S8=S7,SUM(AC7:AD7)>0),AND(S9=S8,SUM(AC8:AD8)>0))))),"PLAYOFF")" which works perfectly.
In AK7 & AK6 it will automatically show when they are either "Auto" or "Champs", but i want it to also show that they are "Play Off" before they get to that stage, it looks wrong that 3rd place has "Play Off", but the other two do not.
In AK7 the formula is: "=IF(OR(AND(S7>MAX(AJ8:AJ29),S7<AJ6),AND(AND(S6=S7,SUM(AC6:AD7)=0),AND(S7=S8,SUM(AC7:AD8)=0))),"AUTO")"
In AK6 the formula is: "=IF(S6>MAX(AJ8:AJ29),IF(OR(S6>MAX(AJ7:AJ29),AND(S6=S6,SUM(AC6:AD7)=0)),"CHAMP","AUTO"))"
In effect i want...
AK7 to show "PLAY OFF" before it shows "AUTO"
AK6 To Show "PLAY OFF" before it shows "AUTO" before it shows "CHAMP"
Hopefully this is okay and you understand, if not i will try the upload document.
Thanks for looking
Regards
