本文介绍了Google电子表格公式可以获取最后一个值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

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



我有一个简单的产品电子表格,其中包含产品名称的列,例如 产品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电子表格公式可以获取最后一个值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-29 06:16