Excel - increasing ...
 

  You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more

[Closed] Excel - increasing denominators by 1 in a range of 300 cells

3 Posts
2 Users
0 Reactions
60 Views
Posts: 1103
Free Member
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
Posts: 10567
Full Member
 

If the denominator is in a cell of its own then fill / series / increase by 1


 
Posted : 06/12/2019 3:10 pm
Posts: 1103
Free Member
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
Posts: 10567
Full Member
 

That's like a Strava PB for me!


 
Posted : 06/12/2019 8:46 pm

6 DAYS LEFT
We are currently at 95% of our target!