Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
Topic starter
Is there a way of increasing the denominator by 1 in each cell in a column instead of manually?
Most rows are divided by the same number but 20+ are divided by different smaller numbers.
Thanks
Posted : 06/12/2019 2:59 pm
If the denominator is in a cell of its own then fill / series / increase by 1
Posted : 06/12/2019 3:10 pm
Topic starter
Thanks. They're in a formula so I've created a column containing just them from a count function.
Posted : 06/12/2019 4:15 pm
That's like a Strava PB for me!
Posted : 06/12/2019 8:46 pm