V
V
Vasya Bulka2022-01-07 14:52:16
Spreadsheets
Vasya Bulka, 2022-01-07 14:52:16

How to put down a group of dates in a table?

The essence of the problem: when stretching a group with a date, the dates are not put down as needed, but simply copied.

You need to stretch "group_1" with one date so that other groups have the next date.

It should be like this:
- Group_1
1.1.22
1.1.22

- Group_2
2.1.22
2.1.22


It turns out like this:
- Group_1
1.1.22
1.1.22

- Group_2
1.1.22
1.1.22

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2022-01-07
@Anonymous24

A4:A6

="— Группа_"&ОКРУГЛВНИЗ((СТРОКА()+2)/3)
=A2+1
=A5

And copy this block
Demo table

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question