The Sheet has a column with cells populated by a dropdown list offering 3 choices: Good; Very Good; Rejected;  In that context, it would be practical to sort the column according to a specific/custom order on those 3 values, no matter the alphabetic order.  E.g.: Rejected in first, Very Good in second and Good in last.  Filter offers only A-Z or Z-A. Is there a way to decide the order base on values in a column?
121870
I'm using a Query in Google Sheets to pull data from another sheet. That query looks something like this:  =QUERY('Raw Data'!A2:AB,"SELECT E, A, C, D, Y, R, S WHERE S = 'New York'",1 )   What I'd like to do, though, is build a custom sort order within the function so that the Query automatically sorts by rows that have "string1" in column E, followed by those that have "string2" in column E, etc etc. The desired order is not alphabetical so I can't use a clause to sort in ascending or descending order.  I'd also prefer to do this without having to create another sheet where I rank my sort order in a table.
33374
I've got a report being built from a dataset. The dataset uses the Sort property to order the data. I know that I can create a sort expression like this:  "field desc, field2 asc"  But what I need now is a way to do a custom sort. In SQL, I can perform a custom sort by doing something like this:  order by      case when field = 'Some Value' then 0 end     case when field = 'Another Value' then 1 end   To basically re-define my sort (i.e, Some Value comes before Another Value).  Is it possible to do something similar as a sort expression against a DataView?
98776
Is there a way to display the unique values in a column ONLY?  Example:   AAPL AAPL AAPL AAPL AKAM AMZN AMZN AMZN AMZN AMZN AMZN  Expected result:   AAPL AKAM AMZN  I have already done a sort for multiple factors, and the first match for each is the best match.  I'm not sure if this is a vlookup or something else.
5646
Basically, I need to do what the title says on my spreadsheet here. So for row 3, I need to find the address of the last non-blank cell in that row, while skipping the grayed out columns (with the header "Total").
98905
How would you determine the column name (e.g. "AQ" or "BH") of the nth column in Excel?  Edit: A language-agnostic algorithm to determine this is the main goal here.
16701
Trying to determine a way that I can use a custom menu (.createMenu) with views that will allow me to show / hide specific columns.  I need the capability to pick specific multiple columns and not ranges.  In the example below how can you pick a custom view from the menu (say "Customer Info") that will only show columns A, B, C, and H?  Maybe another view could show "Financial".
11195
I found an example in the  for Dynamic LINQ that allows you to use a sql-like string (e.g. OrderBy("Name, Age DESC")) for ordering. Unfortunately, the method included only works on IQueryable&lt;T&gt;. Is there any way to get this functionality on IEnumerable&lt;T&gt;?
70181
I have a table and I am always getting the data by ordering a column. In my case, I  order by datenum. However, the selection is so slow because of the ordering.  Is it possible to order the table after datenum. This column is defined as unique. If  defined as an index, would the selection will be faster?
58660
I have jQuery but I'm not sure if it has any built-in sorting helpers. I could make a 2d array of each item's text, value, and selected properties, but I don't think that javascript's built in Array.sort() would work correctly.
89532
Using SharePoint 2013, I have a list column of type Number, and I'd like to restrict it to either whole / half numbers, i.e. 0.5, 1, 1.5, 2, 2.5. But values such as 3.4, 2.6 wouldn't be allowed.   A choice column is unsuitable as the range users will input could go into the 100's.  Can I use custom validation on the column for this and if so how?
15215
I have 3 fields ( Exposed filter ) 1 Country 2 State 3 City  When a respective Country is selected in the 1st field, I want the second filter ( Dropdown or autocompete ) to display states of the country selected in the 1st field &amp; when this is done based on the state selection , I want the 3rd field to show only the cities belonging to the state selected in the second field.  How can this be done ? any help ?
102834
How can I get the Google Spreadsheet to automatically order the incoming form responses alphabetically (2nd column)?   I know how to do this manually or by going in and editing a cell, but cannot get it to do this as an onevent for incoming response.
34232
hope someone can help to crack this one?  I've got a table on my data entry tab (sheet 1) where each row includes two data validation drop down lists (source is on sheet2). I want the options in the second drop down list (k13) to be dependant on what is selected in the first drop down list (g13)...  ie. if you select 'Diary' in the first drop down box then the second drop down only has 'Cheese', 'Milk' and 'Yogurt' - likewise, if you select 'Fruit' in the first box - I want the only options to be available specific to that categories column in the lookup table on sheet 2 (which are 'apple', 'pear' and 'banana' in this case)?  Please help - i think this is a vlookup indirect formula??
75236
I have imported a webpage table in to Google Sheets. It frequently being updated. A series of calculations has been conducted on the sheet named Shawn Of the link spreadsheet.  I have filtered the my desired results into the Calculation sheet of that linked document... which is in columns A5:A. I then applied =ARRAYFORMULA(if(A5:A200=&quot;&quot;,,A5:A200*{12,13,37,101,111})) in columns B5. The Results of the formula extends from B5:F. This results from a5:F was subsequently conditionally formatted to highlighted duplicates in the aforementioned, i.e. a5:f using the lists of values in K5:K and I5:5. In Columns A5:F, is it possible to generate/place values in the range A5:f with matching name of states and aligned values in J5:K and H5:I?
13700
I have a list of objects I wish to sort based on a field attr of type string. I tried using -  list.sort(function (a, b) {     return a.attr - b.attr })   but found that - doesn't appear to work with strings in JavaScript. How can I sort a list of objects based on an attribute with type string?
63040
I want to get the picklist values of a picklist field in Apex.  I use the someFieldResult.getPicklistValues(); function and that works fine. This gives me all the picklist values, in alphabetic order (e.g. Alpha, Beta, Gamma).  However, I want to have those values in the order they were entered (e.g. Gamma, Alpha, Beta). How to do that?
79673
e.g,  foo1 foo2 foo10 foo100   rather than  foo1 foo10 foo100 foo2   Update: not interested in coding the sort myself (although that's interesting in its own right), but having the database to do the sort for me.