Sunday, July 31, 2011

yogi_Automatically Sort Data In Rows Of A Table Based On Values In Another Column

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

Peter-27 said:
How do i autosort values in a table?
On the results page there are three tables.
1st table is to input data.
2nd table turns the inputed data into different numbers (required for what i'm trying to do)
3rd table is the same as the second, but i want it to automatically sort based on the Total, T column.
How do i get this autosort?
In sheet named Results, TABLE C is sorted based on values in range T16:T26 in TABLE B
I have considered the required sort options for TABLE C to be ascending, descending, or restore based on range T16:T26 in TABLE B.