如果单元格满足特定条件然后恢复正常，如何多次重复单元格？

I believe that it is impossible to do what the question asks for with a closed-form, single-cell formula.  Consider the following hypothetical data, with the corresponding desired results (as I understand the requirements):

There's no local difference between Rows 83 & 84 and Rows 86 & 87.  I believe it's impossible for a formula in Column F (or G) to distinguish between those cases without looking at the entire D column.

Luckily, it seems to be fairly easy with helper columns.  Pick two columns that you aren't using.  They can be H and I, Y and Z, AF and AG, or whatever you want.  I'll assume that you choose H and I.

Assuming that your data start in Row 15 (as your question shows) and that cells H14 and I14 are empty (which should be the case, since I've assumed that you aren't using the helper columns), enter

=IF(AND(H14>0,H14<4), H14+1, --OR(TRIM(SUBSTITUTE(D15, CHAR(160), " "))="Depression",TRIM(SUBSTITUTE(D15, CHAR(160), " "))="Hyperinflation"))

into cell H15, and enter

=IF(H15>1, "Depression", TRIM(SUBSTITUTE(D15, CHAR(160), " ")))

into cell F15.  Copy F into G and H into I, and drag/fill down.

The value in the helper column is "normally" 0.  When H(n-1) is 0, Hn is set to --OR(D15="Depression",D15="Hyperinflation") (the final part of the IF expression).  We use TRIM() because the data in your file have trailing spaces, which cause the string comparison to fail.  We use SUBSTITUTE(cell, CHAR(160), " ") because the data in your file have trailing non-breaking spaces, which TRIM() doesn't handle, so we have to convert those to regular spaces before calling TRIM().  This OR expression is TRUE if Dn is equal to one of the two trigger words, and FALSE otherwise.  The -- turns these into 1 and 0.  A value of 1 indicates that this is the first row of a repeat block; a 0 indicates that it is another normal row.

如果为正但小于 4，则表示第n-1行 是重复块的一部分（但不是最后一行），因此第n行 必须是重复块的一部分（但不是第一行）。因此我们添加 1（表达式的中间部分），以表示第 n行是重复块的第 2、第 3 或第 4 行。如果 是 4，我们回到基于 的 设置。H(n-1)IFH(n-1)HnDn

column 的公式F表示如果第 n行是重复块的第 2、3 或 4 行，则设置为“凹陷”；否则，它被设置为等于 。FnDn