在我的Google表格中,我需要在J2和J32之间的最后一个填充的单元格中获取数字。几乎每天都会有一个新的Cell。比如这里我需要得到J27:
In my Google Sheet I need to get the number in the last populated cell between J2 and J32. A new Cell is populated almost daily. For example here I need to get J27:
的
到目前为止,我一直在用31条IF语句来完成它:
So far I have been doing it with 31 IF statements:
=IF( J32 = "", IF( J31 = "", IF( J30 = "", IF( J29 = "", IF( J28 = "", IF( J27 = "", IF( J26 = "", IF( J25 = "", IF( J24 = "", IF( J23 = "", IF( J22 = "", IF( J21 = "", IF( J20 = "", IF( J19 = "", IF( J18 = "", IF( J17 = "", IF( J16 = "", IF( J15 = "", IF( J14 = "", IF( J13 = "", IF( J12 = "", IF( J11 = "", IF( J10 = "", IF( J9 = "", IF( J8 = "", IF( J7 = "", IF( J6 = "", IF( J5 = "", IF( J4 = "", IF( J3 = "", IF( J2 = "", "", J2 ), J3 ), J4 ), J5 ), J6 ), J7 ), J8 ), J9 ), J10 ), J11 ), J12 ), J13 ), J14 ), J15 ), J16 ), J17 ), J18 ), J19 ), J20 ), J21 ), J22 ), J23 ), J24 ), J25 ), J26 ), J27 ), J28 ), J29 ), J30 ), J31 ), J32 ) - Gesamt!Y$34我怀疑它没有给我正确的结果因为有些数字有时会被忽略。有没有更好的方法来做到这一点?
I have the suspicion that it's not giving me the correct results, as some numbers are off sometimes. Is there a better way to do this?
推荐答案我建议:
I suggest:
=vlookup(1E+100,J2:J32,1)但如果任何J2的数字,这可能给不正确的答案:J32是一样大或比更大:
though this could give an incorrect answer if any of the numbers in J2:J32 are as big or bigger than:
10,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000。
10,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000.
假设在J2和J32之间的 在搜索范围内同时包含J2和J32。
The assumption is that between J2 and J32 includes both J2 and J32 in the search range.
更多推荐
在列中查找最后一个值
发布评论