Google电子表格公式可以获取最后一个值 [英] Google Spreadsheet Formula to get last value in a row

问题描述

我想知道是否有人可以用我希望的简单公式来帮助我。

我有一个简单的产品电子表格，其中包含产品名称的列，例如 产品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中工作。

任何想法都会受到欢迎。

以下是我喜欢它看起来像。
http://i.imgur.com/jqcNW.png

很多预先感谢

解决方案

我设法做到了：）

公式

=指数（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电子表格公式可以获取最后一个值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！