sortingvalidationgoogle-sheetsdropdownstring-formatting
How to sort by number in data validation
I have currently a problem where I am trying to filter based on numbers that I have put on in data validation:
As you can see the numbers goes from 1 to 11 and when I am using the filter to sort A-Z, it goes by 1, 10, 11, 2, 3, 4, 5 ...
and I wonder how can I filter it by going numberic? meaning 1,2,3,4,5,6,7,8,9,10,11 ?
Solution
one way would be to use 01 prefix instead of 1
this would then sort:
01
02
10
11
- Sort a 2d array by a column and preserve first level keys
- Sort keys of an array
- How to naturally sort dates formatted as "Y_\mn"
- Sort single-column rows of a 2d array by string prefix in a custom order then by string suffix naturally; and re-apply original keys to result
- Sort a 2d array by multiple column values
- Sort by display name instead of actual value
- How to order a data frame by one descending and one ascending column?
- Sorting by integer value
- Sort a 2d array by values in a column related to a flat priority array
- How can I use PHP to sort a two dimensional array?
- Sort multi dimensional array in php
- Sort a 2d array by column value and preserve numeric first level keys
- Naturally sort a subset of data within a multidimensional array
- Synchronously sort multiple separate arrays by sorting one array naturally
- What exactly does the while loop do here in insertion sort?
- How to find the median of deepest subarrays of multidimensional array?
- Sort a 2D array by one of its columns
- Sort an array of single-element arrays by float value
- Sort a 2d array by one of the columns
- Sort a 2D array by a column DESC
- Sort a 2d Array by a column
- Sort second level arrays of a three-level array by column
- Sort an array of single-element arrays by value descending and preserve keys
- Sort each subarray of a 2d array by delimited string values
- What's the fastest algorithm for sorting a linked list?
- How do i sort an array of array in PHP?
- Optimal algorithm for returning top k values from an array of length N
- Naturally sort an array of objects by column value
- How to sort an array by its keys
- Sorting a flat array returns 1 instead of the modified array