Challenge No. 239: Replace the vowels with vowels in sorted order.
Solved using: Excel VBA.
SORT
Sorts an array in ascending or descending order in Excel.
Unique Names with Sequence
Challenge No. 237: Prepare the result table from Problem table.
Solved using: Power Query.
Sort Rows by Key Count
Challenge No. 223: Sort the rows in columns A through H as per Sort key.
Solved using: Power Query.
Top Headers by Total
Challenge No. 220: First row is column headers and first column is row headers.
Solved using: Power Query (List.Transform).
Golden Period!
Challenge No. 140: For each customer, extract the ten consecutive days with the highest purchases.
Solved using:Excel (FILTER, HSTACK, IFS), Google Sheets, Power Query (Table.AddColumn, Table.Group), Python in Excel, and R.
Sum Bird Quantity Alphabetically
Challenge No. 64: Looks like yesterday’s problem was a difficult one as only one person responded.
Solved using: Power Query (Table.Group, Table.Sort).
Top Player by Group Average
Challenge No. 197: List the qualifying player from each group on the basis of
1.
Solved using: Power Query (Table.AddColumn).
Find Anagram Word Pairs
Challenge No. 187: An Anagram is a word which is made by rearranging the letters of another word.
Solved using: Power Query.
List Buy and Sell Balances
Challenge No. 54: From the transaction table, generate output as shown.
Solved using: Power Query.
Max Items Within Budget
Challenge No. 180: Provide a formula to list the maximum number of items (one unit only of each item) which can be bought in $150 from A2:A10.
Solved using: Power Query (Table.Sort).