Overview Chat Bike Members News Women
Viewing 4 posts - 1 through 4 (of 4 total)
  • Excel – increasing denominators by 1 in a range of 300 cells
  • mrsheen
    Free Member

    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 4 years ago
    BigJohn
    Full Member

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

    Posted 4 years ago
    mrsheen
    Free Member

    Thanks. They’re in a formula so I’ve created a column containing just them from a count function.

    Posted 4 years ago
    BigJohn
    Full Member

    That’s like a Strava PB for me!

    Posted 4 years ago
Viewing 4 posts - 1 through 4 (of 4 total)

The topic ‘Excel – increasing denominators by 1 in a range of 300 cells’ is closed to new replies.

Overview Chat Bike Members News Women