Need help from Google Sheets guru )))

  • 1
  • Question
  • Updated 3 years ago
  • Answered
Office style programs is not my thing, especially spreadsheets. This is why I am seeking for some help from those who know they way around those. Basically what I want to do is to make rows change their places based on the value of input (higher numbers go up, lower go down). I am not sure if that is even possible. If it is, how do I do that?
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb

Posted 3 years ago

  • 1
Photo of HSuarez

HSuarez

  • 11,896 Points 10k badge 2x thumb
Darius,
The Google Docs and Google Apps Script forums may be useful:
https://productforums.google.com/foru...
https://plus.google.com/communities/1...

Personally I haven't dabbled enough in this area, but someone else may also pitch in.

Thanks,
Hannah
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
Thank you,
I've got this figured out by looking at 'sorting' examples: https://support.google.com/docs/table/25273?hl=en&rd=2

https://support.google.com/docs/answer/3093150
Photo of HSuarez

HSuarez

  • 11,896 Points 10k badge 2x thumb
Thanks for the link!
Photo of mlm

mlm, Official Rep

  • 4,624 Points 4k badge 2x thumb
There are lots cool things you can do with functions in spreadsheets like filtering specific data onto a separate tab which is very useful.

But I think what you are trying to do is as simple as sorting the column Z-A in by clicking the little triangle drop down under the column.
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
mlm,

I figured that out already. I needed spreadsheet to do sorting for me, automatically, after I inserted data. Like I said, office programs aren't my thing, but I got it... have some cool stuff coming  ))))
Photo of mlm

mlm, Official Rep

  • 4,624 Points 4k badge 2x thumb
Here is the method I use...

I like to keep all my raw data in one separate sheet called "imported". I do this because sometimes my data may be imported xml that contains items I dont plan to to display.

Then in another sheet I will add the following query:

=(query(imported!A:N,"select A,B,C,D,E,F,G,H,I,K,L,M,N order by A desc"))

In the example above I wanted to to grab all the data from sheet "imported" except for column J and then sort the data in reverse order as you want (this works great for sorting by most recent time stamp).


EDIT: Just saw you got it working, great!  Hopefully this will help someone else that comes across this thread
(Edited)
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
thanks mlm,

this is what did the trick for me: =SORT(A1:B3, 2, FALSE)