Challenge No. 195: Twin primes are those 2 prime numbers where difference between them is 2.
Solved using: Python in Excel.
LAMBDA
Creates custom reusable functions in Excel.
Trim Characters Before Asterisk
Challenge No. 194: Remove the characters preceding the asterisks.
Solved using: Power Query.
Custom Grouping! Part 7
Challenge No. 133: Group the monthly sales values into three categories based on the following logic and provide one of the result tables:
Group 1: 1st to 10th of the month
Group 2: 11th to 20th of the month
Group 3: 21st to the end of the month.
Solved using:Excel (DATE, DAY, DROP), Google Sheets, Power Query (Table.Group, Date.Month, Table.AddColumn), Python, Python in Excel, and R.
Find Missing Letters in Order
Challenge No. 193: Listed are the strings where letters are in increasing order.
Solved using: Power Query.
Year Plus Digits Equals Current
Challenge No. 192: Excel formulas permit date range from 1-Jan-1900 to 31-Dec-9999.
Solved using: Python in Excel.
Merge! Part 3
Challenge No. 132: In Question Table 1, values are provided for each code.
Solved using:Excel (FILTER, FIND, ISNUMBER), Google Sheets, Power Query (Text.Contains, Table.AddColumn, Table.SelectRows), Python, Python in Excel, R, and VBA.
Find Max Sum Pairs
Challenge No. 190: Find the unique pairs of numbers whose sum is the maximum.
Solved using: Python in Excel.
Count Larger Numbers Below
Challenge No. 189: Populate the count of numbers larger than the number given in a cell.
Solved using: Python in Excel.
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).
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.