V E Meganathan

Sequence of Numbers Based on Given Number of Digit: Input Digit - 2 Result - Generate sequence of numbers from 10 to 99. Excel: =LET(n,A2,s,10^(n-1),SEQUENCE(10^n-s,,s)) Power Query: let n = 2, Result = {Number.Power(10, n-1)..Number.Power(10, n) - 1} in Result Python in Excel: n = xl("A2") [i for i in range(10 (n-1), 10 n)] Sequence of Numbers 1; 2; 2; 3; 3; 3;4; 4; 4; 4: Excel: =LET(n,A2,s,SEQUENCE(n),TOCOL(IFS(s>=TOROW(s),s),3)) Python in Excel: n = xl("A2") L = [[i for x in...

Excel: Trick to Divide a Number by 100 - Excel: Formula in B2 cell, =A2:A9% Power Query: Advanced Filter using Table.FindText - Power Query: Our goal is to apply filter and select rows which contains '*'. let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], Result = Table.FindText(Source,"*") in Result Python in Excel: Flatten a List - Python in Excel: Input data contains nested list structure. L = [ [112,234], [1011,1210], [3216,5678] ] Our goal is to make it a single list....

Trick - 1: Extract 2 Characters at Each Position: t = 'RickRothstein' [''.join(i) for i in zip(t,t[1:])] or, [b+c for b,c in zip(t,t[1:])] Today, I explored the task of extracting two-characters from each position within a string. Driven by my interest in learning Python, I sought an effective approach to accomplish this. Consider a sample input string such as 'rothstein'. Since strings in Python are iterable, I began by applying the zip function to two versions of the text. The first version...