横向扩展的数据怎么每次都去取最后两列的数据进行计算，上图的月份是单元格横向拓展出来的，需要每次都取最后显示的两个月 现在公式是if(nvl(INDEXOFARRAY(SPLIT(C14, ","), len(SPLIT(C14, ","))),0)=0 || nvl(INDEXOFARRAY(SPLIT(C14, ","), len(SPLIT(C14, ",")) - 1),0)=0 ,'-',INDEXOFARRAY(SPLIT(C14, ","), len(SPLIT(C14, ","))) / INDEXOFARRAY(SPLIT(C14, ","), len(SPLIT(C14, ",")) - 1) - 1)
本来应该是0却算出来了 |
1min目标场景问卷
立即参与
最佳回答 |
||||
|
0
|
|
|||
