Danfrancozola
New Member
- Joined
- Sep 1, 2014
- Messages
- 19
Hello all,
I am currently doing a charity world cup predictor and need some help.
When calculating the group tables, I have entered a formula so that the teams in each group are ranked by points, then goal difference, then goals scored.
When one or more team are on the same totals, the teams are repeated. For example England is shown twice in the final group standing.
The following formula is in R47:
=COUNTIF($AA$47:$AA$50,">"&AA47)+1+COUNTIFS($AA$47:$AA$50,AA47,$Z$47:$Z$50,">"&Z47)+COUNTIFS($AA$47:$AA$50,AA47,$Z$47:$Z$50,Z47,$X$47:$X$50,">"&X47)
Then I have the next formula in AD47:
=IFERROR(VLOOKUP(AC47,$R$46:$AA$50,2,FALSE),VLOOKUP(AC47,$R$46:$AA$50,2,TRUE))
Can anyone please correct either of these so that the information shown in the final group standings table is not repeated?
Thanks,
Dan
I am currently doing a charity world cup predictor and need some help.
When calculating the group tables, I have entered a formula so that the teams in each group are ranked by points, then goal difference, then goals scored.
When one or more team are on the same totals, the teams are repeated. For example England is shown twice in the final group standing.
The following formula is in R47:
=COUNTIF($AA$47:$AA$50,">"&AA47)+1+COUNTIFS($AA$47:$AA$50,AA47,$Z$47:$Z$50,">"&Z47)+COUNTIFS($AA$47:$AA$50,AA47,$Z$47:$Z$50,Z47,$X$47:$X$50,">"&X47)
Then I have the next formula in AD47:
=IFERROR(VLOOKUP(AC47,$R$46:$AA$50,2,FALSE),VLOOKUP(AC47,$R$46:$AA$50,2,TRUE))
Can anyone please correct either of these so that the information shown in the final group standings table is not repeated?
Thanks,
Dan