How to make REPEAT formula in excel using LAMBDA

Опубликовано: 14 Октябрь 2024
на канале: Karina Adcock

26,470

125

Create a formula to get repeating numbers: either 1,2,3,1,2,3 or 1,1,1,2,2,2
Using LAMBDA and SEQUENCE: new formulas in Office 365 Beta Channel
=IF(B10=0,MOD(SEQUENCE(B4*C7,1,0,1),B4)*B7+C4,QUOTIENT(SEQUENCE(B4*C7,1,0,1),B4)*B7+C4)
=LAMBDA(repeat,start,step,stop,type,IF(type=0,MOD(SEQUENCE(repeat*stop,1,0,1),repeat)*step+start,QUOTIENT(SEQUENCE(repeat*stop,1,0,1),repeat)*step+start))(3,1,1,3,0)
---------------------------------------------------------------------------------
#exceltips #exceltutorials #excelformulas

SUBSCRIBE: https://goo.gl/c46YPs

Microsoft Office 365, Beta Channel, Version 2106
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
How to autofill numbers in excel    • How to autofill numbers in excel
How to get repeating numbers in excel 1,2,3,1,2,3    • How to get repeating numbers in excel...
How to get repeating numbers in excel 1,1,1,2,2,2    • How to get repeating numbers in excel...