4 min read
2026-02-06
For the list of prices, use numeric sorting, for names - alphabetical. Alphabetical will put "9" after "10".
Remove extra spaces, convert to one case. Otherwise, the "apple" will end up in a different place than the "Apple".
The Russian alphabet is different from the Latin one. Make sure that the sorting takes into account the Cyrillic alphabet correctly.
Sort first, then remove duplicates—or use both tools together.
Empty lines, lines with spaces, numbers with a fractional part - all this can affect the result.
To understand how sorting works:
Quick sort — average O(n log n), the most common
Merge sort — stable O(n log n)
Bubble — O(n²), used for training
Sort the data using Sorting Rows.
See also: Remove duplicates, Flip text