Fill series backwards using formulas

YasserKhalil
PlatinumLounger
Posts: 4911
Joined: 31 Aug 2016, 09:02

Fill series backwards using formulas

Post by YasserKhalil »

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

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Fill series backwards using formulas

Post by HansV »

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

YasserKhalil
PlatinumLounger
Posts: 4911
Joined: 31 Aug 2016, 09:02

Re: Fill series backwards using formulas

Post by YasserKhalil »

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

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Fill series backwards using formulas

Post by HansV »

Enter the formula

=9-ROW()

in A1 and fill down to A8.
Best wishes,
Hans

YasserKhalil
PlatinumLounger
Posts: 4911
Joined: 31 Aug 2016, 09:02

Re: Fill series backwards using formulas

Post by YasserKhalil »

Thanks a lot. Very simple but I complicated the problem a lot. Thank you very much.