问题描述
我想知道是否有人可以用我希望的简单公式来帮助我。我有一个简单的产品电子表格，其中包含产品名称的列，例如 产品B 产品B 产品B 产品B 产品B 产品B 产品D
现在每行都有一些数值
例如
产品 产品A 5.0 2.5 / b>
产品C 2.0 4.0 5.0
产品D 3.0
Product E 6.0 2.0 1.6 2.9
现在我想要的是在prouct旁边有一个列的公式，它显示了最后输入的值的值一个产品，例如
上面的例子中的值会给我
产品A 2.5
产品B 6.0 b / b
$ b产品C 5.0 b / b
$ b产品D 3.0 b / b
产品E 2.9
在Excel中，我会用INDEX和MATCH来做到这一点，但我无法得到这个在Google Spreadsheets中工作。
任何想法都会受到欢迎。
以下是我喜欢它看起来像。
很多预先感谢
我设法做到了：）
公式
=指数（B2：G2; 1; counta（B2：G2））
I wondered if someone could help me with what I hope is a simple Formula.
I have a simple spreadsheet for Product which has a column for the product name eg
Product A
Product B
Product C
Product D
Now on each row there are some numerical values
eg
Product
Product A 5.0 2.5
Product B 6.0
Product C 2.0 4.0 5.0
Product D 3.0
Product E 6.0 2.0 1.6 2.9
Now what I want is to have a formula for a Column next to the prouct that shows me the value of the last entered value for a Product eg the Values in the above example would give me
Product A 2.5
Product B 6.0
Product C 5.0
Product D 3.0
Product E 2.9
In Excel I would do this with INDEX and MATCH however I cannot get this to work in Google Spreadsheets.
Any ideas would be most welcome.
Here is a screenshot of what I would like it to look like.http://i.imgur.com/jqcNW.png
Many thanks in advance
I managed to do it :)
Formula
=index(B2:G2;1;counta(B2:G2))
这篇关于Google电子表格公式可以获取最后一个值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！