V E Meganathan

Numerous Methods to accomplish a challenge: Challenge: A hundred people stand in a circle, numbered 1 to 100. Number 1 taps number 2 out. Number 3 taps number 4 out. Number 5 taps number 6 out, and so on round the circle. The tapping keeps going, round and round, each person still standing tapping out the next person still standing, until one person is left. Which number survives? Excel: =LET(n,100,L,n-2^INT(LOG(n,2)),2*L+1) =LET(n,100,a,DEC2BIN(n),BIN2DEC(MID(a,2,10)&LEFT(a)))...

📊 Math Curiosity with Excel: Did you know Excel can spark pattern‑hunting curiosity in math? Using this formula: =MAP(SEQUENCE(10),LAMBDA(x,LET(s,x*2+1,a,SEQUENCE(s,,x^2),TEXTJOIN("+",,TAKE(a,x+1))&"="&TEXTJOIN("+",,DROP(a,x+1))))) 👉 For x = 4, Excel generates: 16+17+18+19+20 = 21+22+23+24 ✨ Notice how the left side has x+1 terms, while the right side has x terms. They don’t balance numerically — but they reveal a hidden symmetry in sequences. 🔔 This is curiosity at work: math isn’t only...

🚀 Excel Tip: MAP Without LAMBDA Did you know Excel’s MAP function doesn’t always require a LAMBDA? If you pass a built‑in function directly, Excel auto‑wraps it behind the scenes — but only if the order of arrays matches the order of the function’s arguments. =MAP(A3:A6,B3:B6,C3:C6,MID) This works because: A3:A6 → goes into MID’s text argument B3:B6 → goes into start_num C3:C6 → goes into num_chars Excel interprets MID as if it were wrapped in: LAMBDA(text,start,num_chars,MID(text,start,num_...