Thread: [Solved] Calculate league standings in a fixture list
View Single Post
 
Old 01-04-2024, 05:47 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Quote:
Originally Posted by Matin View Post
positions 1,2, 3, 4, 6, 7 and 17 are important in a 20 team league because they determine the Winner, European places and Relegation zone whereas the rest are kind of pointless to have so it would be a waste of space to have them all.
Wrap the existing formula in:
=INDEX(theExistingFormula,,{1,2,3,4,6,7,17})
Reply With Quote