Viewing 4 posts - 1 through 4 (of 4 total)
  • Excel – increasing denominators by 1 in a range of 300 cells
  • Premier Icon 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

    Premier Icon BigJohn
    Full Member

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

    Premier Icon mrsheen
    Free Member

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

    Premier Icon BigJohn
    Full Member

    That’s like a Strava PB for me!

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.