在Excel上填写丢失的数据

发布于 2025-02-02 18:46:47 字数 360 浏览 1 评论 0原文

我正在尝试比较两个不同股票的数据集，但它们缺少数据，导致其日期混合在一起。结果，库存A的时间和价格比库存B短。我想平衡这些列，以便它们的值与它们的值相同。我尝试使用if语句，但由于股票A有时会连续丢失多行数据，但它缺乏。理想情况下，缺少数据的空间将填充差距之前的值。例如，如果价格上涨： 1、2、3、4，空白，5 它将更改为： 1、2、3、4、4、5 如果空白实际上是空白，但它们充满了值，这将很容易做到。

IF(B80=D80,C80,C79)

原文

I'm trying to compare data sets of two different stocks but they have missing data causing their dates to be mixed up. Stock A as a result has a short column for time and price than stock B. I'd like to balance these columns out so they have the same amount of values in them. I tried using an if statement but it fell short since the stock A sometimes had multiple rows of data missing consecutively.
Ideally, the spaces where the data is missing would be filled with the values that preceded the gap. For instance, if the prices went:
1, 2, 3, 4, blank, 5
It would be changed to:
1, 2, 3, 4, 4, 5
This would be easy to do if the blanks were actually blank but they're filled with values.