yogi_Sort In Ascending Order A Sheet By #n Which is Part of Cells In Column B

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #666   Aug 03, 2012     www.energyefficientbuild.com.


user Sander121 said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/SjU-fCoQZ2Y)
Hello,

I want to sort my sheet, but not from A > Z. It should be that when i arrange the column, the other cells in that row should go with it. Does anyone know how to do that?

Example:

https://docs.google.com/spreadsheet/ccc?key=0Aq9qjbt_5Ja_dFp0cUxRcFF1QjYzVlZKdmpuS1Jjb2c#gid=3

------------------------------------------------------------------------------------------------

following is a solution to the problem