连续获取最后一个非空单元格 [英] Getting the last non-empty cell in a row

问题描述

我在想出一种方法来解析"和排序"我的excel电子表格时遇到很多困难.我本质上需要做的是从每行中获取最后一个非空单元格，并将其剪切/粘贴到新列中.

I am having a lot of difficulty trying to come up with a way to 'parse' and 'order' my excel spreadsheet. What I essentially need to do is get the last non empty cell from every row and cut / paste it a new column.

我想知道是否有简单的方法来做到这一点?

I was wondering if there is an easy way to do this?

我非常感谢您的任何建议.提前非常感谢！

I appreciate any advice. Many thanks in advance!

推荐答案

您的值是数字的还是文本的(或者可能是两个)?

Are your values numeric or text (or possibly both)?

对于数字，使用Z2中的此公式获取最后一个值

For numbers get last value with this formula in Z2

=LOOKUP(9.99E+307,A2:Y2)

或输入文字....

=LOOKUP("zzz",A2:Y2)

或两者之一...

=LOOKUP(2,1/(A2:Y2<>""),A2:Y2)

无论数据中是否有空格，所有公式都有效……

all the formulas work whether you have blanks in the data or not......

这篇关于连续获取最后一个非空单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！