Friday, October 4, 2013

yogi_WorkAround For Showing Data in Reverse Order (Last Eneterd First Shown ... like LIFO ... Last In First Out)

                                          Google Spreadsheet   Post  #1380
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