Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
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.
In case of a tie in table C, how would i sort by number of 10's then 8's then 6's then 5's then 4's then then 3's then 2's then 1's in Table C between columns C and S?
ReplyDeleteHi Peter:
ReplyDeleteI have created another sheet named ResultsInCaseOfATie to take into account your revised specification.
Please check it out and let me know how it works out for you.
Cheers!
Yogi