Forum menu
Excel - increasing ...
 

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

Posts: 1110
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 3:59 pm
Posts: 10725
Full Member
 

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


 
Posted : 06/12/2019 4:10 pm
Posts: 1110
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 5:15 pm
Posts: 10725
Full Member
 

That's like a Strava PB for me!


 
Posted : 06/12/2019 9:46 pm