Forum Discussion
Solved
Sequence Function based on 2 values
Hello Excel Community - Not sure if the sequence function can do this, but I figured I'd ask someone smarter than I. I love the Sequence function! I am using it for Levels. I enter the number o...
I don't know how to make SEQUENCE repeat values. Here is a formula that will work in older versions of Excel too.
Name the cell with the number of levels Levels, and name the cell with the number of zones Zones.
In a cell in row 1, enter the formula
=IF(ROW()>Levels*Zones,"",QUOTIENT(ROW()-1,Zones)+1&"-"&MOD(ROW()-1,Zones)+1)
Fill down a long way.