Friday, February 7, 2014

yogi_Formula For Sorting In-Situ A Table Resulting From A Formula

                                         Google Spreadsheet   Post  #1521
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-07-2014
post by Robert Warner question by Allana M.2 (https://productforums.google.com/forum/#!mydiscussions/docs/3cLYffOYn9Y)

Further help would be great. I have three columns (so far) that will need to be sorted by another user as requested. 


It's not absolutely necessary, but I'd like the other user to be able to see a neat display of user addresses in each column, rather than read the page from top to bottom with a bunch of empty spaces in between. 

Maybe we could instead create a third step that delete all the empty cells and moves filled cells up? (Obviously I'm not committed to row integrity here, or even sorting alphabetically.)
---
Oh, Google permissions. If only you were remotely straightforward. 

https://docs.google.com/spreadsheet/ccc?key=0AoJS-UKo3Mi5dERRTERXaERBRE5lejFYWEs4blpqd0E&usp=sharing

Your form questions are a bit silly, in this case: The formula I need help with is yours; it's in the third sheet (FOR THE PUBLIC).
------------------------------------------------------------------------------------------------------------------