在 Google 表格中的两个数字之间的列中填充数字 [英] Fill numbers in column between two numbers in Google Sheets

问题描述

所以我试图在 Google 表格中的两个单元格之间填充数字.我从 270 开始，我需要在列中几个不确定和不同的空单元格之后达到 180.我需要它们之间的单元格均匀填充.但是如何?

So I'm trying to fill in the numbers between two cells in Google Sheets. I start with 270 and I need to get to 180 after several indefinite and varying empty cells in the column. I need the cells between them evenly filled. But how?

推荐答案

如果你想将这些值粘贴到你需要做的同一列中:

if you want to paste those values in the same column you need to do:

那么公式将是:

=ARRAYFORMULA(INDIRECT("A"&
 MAX(IF(A3:A<>"", ROW(A3:A), )))+SORT(ROW(INDIRECT("A1:A"&
 MAX(IF(A3:A<>"", ROW(A3:A), ))-2)), 1, 0)*(A1-INDIRECT("A"&
 MAX(IF(A3:A<>"", ROW(A3:A), ))))/(
 MAX(IF(A3:A<>"", ROW(A3:A), ))-1))

这篇关于在 Google 表格中的两个数字之间的列中填充数字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！