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 🙂

This entry was posted on Wednesday, September 27th, 2017 at 4:52 pmand is filed under . You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

Comments are closed.