Big thanks to Ninad Barbadikar for his tutorial which you can find here.
This is the calculation that makes it possible; IF INDEX()%2=0 THEN INDEX()-1 ELSE INDEX()*-1+1 END