Excel: How to count backwards / reverse / counting down with autofill

this simple approach might get complicated and have many ways to resolve, but here is my suggested solution:

counting down from 4 to 0,  use: =5-row(A1)

this might be useful if you want to transpose also the direction.

A                B
Head               formular

Index1                =index(a$2:a$4;5-row(A1))
Index2                =index(a$2:a$4;5-row(A2))
Index3                =index(a$2:a$4;5-row(A3))

counting down from 4 to 2 🙂


Comments are closed.