arrayssortinggoogle-sheetsgoogle-sheets-formulagoogle-sheets-query
Sort Data By the 2nd Last Letter in a cell then the first- Google Apps Script / Google Sheets
In the image shown (highlighted Bright Green G:H), I would have liked to sort the data according to the 2nd last letter - not the first. This would have meant F01A1 should have been appeared higher in list than E09C1, and then would have been selected in the A column.
How could I have the data Sorted by 2nd Last Letter in Cell, in Column G:H ?
Solution
try in row 1:
=ARRAYFORMULA(QUERY({G:H, RIGHT(H:H, 2)}, "select Col1,Col2 order by Col3", 0))
- Search for sequence of bytes in python
- Combining and aggregating key/value pairs across different events/rows
- 2D NumPy array + 1D array →?
- Sort the rows of a 2d array by a column to be ordered by another flat array
- How do I print bytes as hexadecimal?
- Naturally sort an associative subarray by its keys in a descending direction
- Group rows by one column and populate subarray within group with another column's value
- Group row data of a 2d array by a column and push another column as subarray items per group
- Group 2d array data by one column and create a subarray in each group from another column
- Group row data from a 2d array by one column and populate the group's subarray with another column
- Dynamic array using xlwings causing formula to be wrapped with {}
- Grouping data while looping by one value and push another value into the group as a subarray value
- Check array in JS - is list sorted?
- HackerRank: New Year Chaos alternative answer Java
- When is array allocated on stack in C#?
- Group 2d array data by a column and only create a subarray if more than one item in group
- How to perform grouping in php
- Difference between using Array.isArray and instanceof Array
- Order of operations - using two assignment operators in a single line
- Is there a way in array.map() method to access / iterate the keys of multiple key/value-pairs per index (not the index)
- Sort columns in an associative array of indexed arrays by multiple criteria
- Sort a 2d array by another flat array of priority values
- Sort a 2d array by a column's values
- Sort a 2d array by a column and preserve first level keys
- Sorting a 2d array by numeric column value
- PHP Sort Array By SubArray Value
- How to stop the results repeating and keep updated record from the cart array?
- Sorting a 2D array by a column
- Sort a 2d array containing only one column and preserve first level keys
- Sort a 2d array by a column then print and remove rows