Excel BI Challenge Workout 049

Workouts Excel BI Challenge
1

— CAN YOU SOLVE THIS - EXCEL CHALLENGE 49 —
(Power Query solutions also welcome for Excel Challenges)

Provide a formula to list those numbers in A2:A10 where every succeeding digit is >= previous digit.
Hence, 1336 is a valid answer but 13365 is not a valid answer as 5 is not >=6. Similarly, 51678 is not a valid answer as 1 is not >=5.

(Post answers in Comment. Your formula need not be different from others as long as you have worked out your formula independently)

Download Practice File - https://lnkd.in/dF4zg-y5

#excel, #challenge, #advancedexcel, #excelchallenge, #excelproblem, #excelquestion, #excelsolution, #excelformulas, #excelfunctions, #exceltips, #exceltricks, #powerquerychallenge, #powerbichallenge, #powerqueryproblem, #M, #powerpivot

image
image970×604 70.5 KB

Excel BI’s LinkedIn Post

1 Like
2 
=LET(_rng,A2:A10,
_isvalid,MAP(_rng,LAMBDA(x,--CONCAT(SORT(--MID(x,SEQUENCE(LEN(x)),1)))=x)),
FILTER(_rng,_isvalid))

Quadri Atharu Numbers in Increasing Order.xlsx (23.0 KB)