Hello everyone
How can I get a formula that reverses the serial or fill the series backwards?
I mean the normal series is 1, 2 , 3, 4 and so on
Suppose I need to start the series with 8 and fill the series backwards to be
8, 7, 6, 5, 4, 3, 2, 1
Fill series backwards using formulas
-
- PlatinumLounger
- Posts: 4931
- Joined: 31 Aug 2016, 09:02
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Fill series backwards using formulas
Do you already have data in a column that you want to reverse, or do you just want to provide the highest number and go back from that?
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4931
- Joined: 31 Aug 2016, 09:02
Re: Fill series backwards using formulas
This is just an idea for a problem. The max number is 8 (just need the formula to start with 8 and downwards) .. 8 7 6 5 ... 1
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Fill series backwards using formulas
Enter the formula
=9-ROW()
in A1 and fill down to A8.
=9-ROW()
in A1 and fill down to A8.
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4931
- Joined: 31 Aug 2016, 09:02
Re: Fill series backwards using formulas
Thanks a lot. Very simple but I complicated the problem a lot. Thank you very much.