software

I have a table
A B C D E F G H
1| 5 12 14 7
2| 45 1 77
3| 8 74 12 99 47
4| 4
5| 1 12

In result I want to get last value from each row (in column A)
A B C D E F ...
1| 7
2|77
3|47
4| 4
5|12--
Oleg------------------------------------------------------------------------
Oleg's Profile: www.excelforum.com/member.php...foamp;userid=4004
View this thread: www.excelforum.com/showthread...hreadid=521183I put this formula in I2:
=LOOKUP(2,1/(A2:H2lt;gt;quot;quot;),A2:H2)
And dragged down

Then I converted that column to values:
edit|copy
edit|paste special|values
and deleted columns A:H
Oleg wrote:
gt;
gt; I have a table
gt; A B C D E F G H
gt; 1| 5 12 14 7
gt; 2| 45 1 77
gt; 3| 8 74 12 99 47
gt; 4| 4
gt; 5| 1 12
gt;
gt; In result I want to get last value from each row (in column A)
gt; A B C D E F ...
gt; 1| 7
gt; 2|77
gt; 3|47
gt; 4| 4
gt; 5|12
gt;
gt; --
gt; Oleg
gt;
gt; ------------------------------------------------------------------------
gt; Oleg's Profile: www.excelforum.com/member.php...foamp;userid=4004
gt; View this thread: www.excelforum.com/showthread...hreadid=521183

--

Dave Peterson