Applies a function to each column in an array in Excel.
Challenge No. 43: In the question table (Product sales in different regions), sort the columns in descending order based on their total values.
Solved using:Excel (BYCOL, HSTACK, LAMBDA), Google Sheets, Power Query (List.Skip, Table.Column, Table.ColumnNames), Python, and R.
Challenge No. 33: Questionnaires are a common method for collecting data, but they are susceptible to noise from respondents who fill them out randomly.
Solved using:Excel, Power Query, Python, and R.
Challenge No. 12: In every decision-making process, the first step is to normalize the data.
Solved using:Excel (BYCOL, LAMBDA), Google Sheets, Power Query (List.Transform, Table.FromColumns, Table.ToColumns), R, and VBA.
Challenge No. 11: Extract all item codes that are repeated at least in 3 out of 4 lists presented in the question table.
Solved using:Excel (BYCOL, FILTER, LAMBDA), Power Query (List.Combine, List.Distinct, List.Transform), and R.
