Google Spreadsheet Post #1380
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Sep 28, 2013
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Sep 28, 2013
user Olga Godoy Giménez (http://productforums.google.com/forum/?zx=b71iiwt6rygl#!category-topic/docs/spreadsheets/CyExgxgRXLc)
How can I get the data to appear in reverse order?
'd like the data to appear in reverse order so that new data will appear in the upper rows while old date will move down as new data is entered.
Can this be done? Thanks in advance!
----------------------------------------------------------------------------------------------------------------------------------------------------------------
in the solution presented here,
1) I first created a virtual seconfd column to show corresponding row number of entries in column A
2) then I sorted the entry in column A by row numbers in the virtual column by descending oder
How can I get the data to appear in reverse order?
'd like the data to appear in reverse order so that new data will appear in the upper rows while old date will move down as new data is entered.
Can this be done? Thanks in advance!
----------------------------------------------------------------------------------------------------------------------------------------------------------------
in the solution presented here,
1) I first created a virtual seconfd column to show corresponding row number of entries in column A
2) then I sorted the entry in column A by row numbers in the virtual column by descending oder
No comments:
Post a Comment