Challenge No. 291: Reverse data given in rows.
Solved using: Python in Excel.
SORTBY
Sorts an array based on the values in another array in Excel.
Pair and Sort People
Challenge No. 288: Make groups of 2 persons each in sequence and sort them.
Solved using: Python in Excel.
Reverse Only Vowels in Word
Challenge No. 279: Reverse only the vowels in the given words.
Solved using: Python in Excel.
Sort Words By Embedded Numbers
Challenge No. 277: All words have an one digit number within themselves.
Solved using: Python in Excel.
Sort Words by End Digit
Challenge No. 246: All words have a one digit number as its last character.
Solved using: Power Query.
Sort Numbers Leave Text
Challenge No. 226: Sort the numbers in given strings and leave the non numbers as they are.
Solved using: Power Query.
Sort Columns by Frequency
Challenge No. 188: Sort Col 1 through 5 column wise on the basis of frequency.
Solved using: Power Query (List.Transform).
Sort Cities by Populated
Challenge No. 169: Order the cities columns on the basis of number of cells populated in descending order.
Solved using: Python.
Custom Rank! Part 2
Challenge No. 112: In the question table, rank the products based on the difference between sales in 2023 and 2022, in descending order.
Solved using:Excel (HSTACK, LET, ROWS), Google Sheets, Power Query (Table.AddIndexColumn, Table.Sort), Python, Python in Excel, and R.
Sort with Custom Rules
Challenge No. 129: We had a sorting challenge recently.
Solved using: Power Query.
