Forum Discussion
ttodd0450740
Apr 14, 2021Copper Contributor
Can I save my excel spreadsheet in reverse?
In other words.. instead of my excel spread sheet which is (2278 lines) from 1 to 2278., can it be saved from 2278 to 1 ? Orin this example - April 2021 to January 2016 . as it is now I ca...
mtarler
Apr 14, 2021Silver Contributor
ttodd0450740 if you are on 365 then you can put this formula on a new sheet and substitute the array Sheet1!A1:D7 with the area on the sheet you want to reverse:
=LET(in,Sheet1!A1:D7, r,ROWS(in),c,COLUMNS(in),INDEX(in,SEQUENCE(r,,r,-1),SEQUENCE(,c,1,1)))