英文:
How to create an Even Odd Number Series formula
问题
以下是翻译好的内容：
| 列 A： | 列 B |
|---|---|
| Sku.100 | ck.1 |
| Sku.100 | ck.1 |
| Sku.101 | ck.1 |
| Sku.102 | ck.2 |
| Sku.102 | ck.2 |
| Sku.103 | ck.2 |
| Sku.104 | ck.3 |
| Sku.104 | ck.3 |
| Sku.105 | ck.3 |
列 A：两次偶数，然后1个奇数
列 B：3个相同数字的系列
英文:
is there a way to automatically fill a column with the following sequence:
| Column A: | Column B |
|---|---|
| Sku.100 | ck.1 |
| Sku.100 | ck.1 |
| Sku.101 | ck.1 |
| Sku.102 | ck.2 |
| Sku.102 | ck.2 |
| Sku.103 | ck.2 |
| Sku.104 | ck.3 |
| Sku.104 | ck.3 |
| Sku.105 | ck.3 |
Column A Twice even numbers, then 1 odd number
Column B series of 3 same numbers
Thanks in advance.
答案1
得分: 4
=LET(
x, "Sku." &
TOCOL(
SEQUENCE(
1000,
,
100,
2
) + {0, 0, 1}
),
y, "ck." &
INT(
SEQUENCE(
ROWS(x),
,
,
1 / 3
)
),
HSTACK(x, y)
)
英文:
Assuming there is no Excel Version Constraints, you could try this using SEQUENCE() function.
• Formula used in cell A1
=LET(
x, "Sku." &
TOCOL(
SEQUENCE(
1000,
,
100,
2
) + {0, 0, 1}
),
y, "ck." &
INT(
SEQUENCE(
ROWS(x),
,
,
1 / 3
)
),
HSTACK(x, y)
)
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论