Challenge No. 592: Prepare Bell Triangle for given n where n is number of rows.
Solved using: Python.
LAMBDA
Creates custom reusable functions in Excel.
List Consecutive Streak Indexes
Challenge No. 590: If there are more than one consecutive streaks of H or T, then list the Indexes of those.
Solved using: Python in Excel.
Missing Letters and Frequencies
Challenge No. 589: From the list of longest words in English, list the missing alphabets from English language and also the alphabet whose frequency is the highest (in sorted order).
Solved using: Python in Excel.
Pick top N by group
Challenge No. 271: From first group, pick up top 1 on the basis of revenue, from second group, pick up top 2 and so on.
Solved using: Python in Excel.
Minimum Sum Unique Pairs
Challenge No. 588: Find the unique pairs for which sum in minimum across the columns.
Solved using: R.
Repeat Vowels by Position
Challenge No. 587: Repeat the vowels as per their order of occurrence.
Solved using: Python in Excel.
Animal Park Presence Matrix
Challenge No. 586: List all animals and all parks.
Solved using: Python.
Cross Product with Repeats
Challenge No. 585: Prepare the cross product of Column1 with Column2 where an entry should be repeated by the number in brackets.
Solved using: Python.
Cross Product with Multiples
Challenge No. 584: Prepare the cross product of Column1 with Column2 where an entry should be repeated by the number in brackets.
Solved using: R.
Find Time Extremes by Date
Challenge No. 582: For different dates, document the min and max time and corresponding employees.
Solved using: Python in Excel.