Challenge No. 572: Week 1 starts from 1st of the month.
Solved using: Python in Excel.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Rank stores by percentage of
Challenge No. 263: Table 1 (T1) has got customer satisfaction responses and Table 2 (T2) has got color coding of those responses.
Solved using: Python.
Digit-Constrained Product Numbers
Challenge No. 571: Find the first 500 numbers starting with 10 where number multiplied by its reversed digits contain only those digits which are there in the number.
Solved using: Python.
Swap Letters by Index Pair
Challenge No. 570: For a given string, interchange the alphabets by swapping positions given in Numbers column.
Solved using: Python in Excel.
Absolute Alphabet Frequency Difference
Challenge No. 569: Find the count of alphabets in String1 and String2 and take the absolute difference of count of common alphabets and retain the non-common ones, combine those alphabets along with their counts (sorted alphabetically).
Solved using: Python in Excel.
Transpose the given data from
Challenge No. 261: Transpose the given data from Problem Table into Result table as shown.
Solved using: Python in Excel.
Assign Fruits to Tiers
Challenge No. 566: Populate Fruits1, Fruits2 and Fruits3 against fruits beneath the counts.
Solved using: Python.
Reversed Even Perfect Squares
Challenge No. 565: Find first 50 numbers where both the number and its reversed number are
– Even
– Perfect squares
Ex.
Solved using: Python in Excel.
Sort Only Numeric Columns
Challenge No. 564: Sort the columns where only numbers will be sorted and non-numbers will not be sorted.
Solved using: R.
List the fruits and the
Challenge No. 259: List the fruits and the sum of total amount against a fruit.
Solved using: Python in Excel.