Challenge No. 202: List the names and subjects as well as cell address where the highest marks in the grid appear.
Solved using: Power Query.
COLUMN
Returns the column number of a reference in Excel.
Add Index Column! Part 2
Challenge No. 116: Add an index column to the question table, with a separate counter for each stock.
Solved using:Excel (CHOOSECOLS, CHOOSEROWS, COLUMN), Google Sheets, Power Query (List.Alternate, Table.AlternateRows, Table.Column), Python, Python in Excel, and R.
Generate A to Z letter sequence
Challenge No. 33: Provide a formula to generate the sequence shown (A till Z only).
Solved using: Power Query (List.Transform).