开发者

Excel - Reverse order of rows in Named Range

开发者 https://www.devze.com 2023-03-19 08:44 出处:网络
I\'ve got these Named Ranges that work fine. But they are reversed from the get go because of how data is imported into the worksheet, and I need to re-reverse them again.

I've got these Named Ranges that work fine. But they are reversed from the get go because of how data is imported into the worksheet, and I need to re-reverse them again.

The named range looks like this:

=OFFSET(Numbers1!$D$2;0;0;SUMPRODUCT(IF(Numbers1!$D$2:$D$60<>"开发者_如何学编程";1;0));1)

So is this possible by only altering the formula?

"Reversed" means that it looks like this in the spreadsheet:

201103
201102
201101
201012
201011
201010
201009
201008
201007
201006
201005
201004
201003
201002
201001
200912

What I'm after is to reverse the order so that the number at the bottom (200912) comes at the top, etc etc.


You could use this formula e.g. in cell E2 and drag down:

=IF(COUNT(D2:D$60)<1,"",OFFSET(D$2,COUNT(D2:D$60)-1,0))

The result is the same numerical values as at the top of D2:D60 but in reverse order.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号