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: http://www.excelforum.com/member.php...fo&userid=4004
View this thread: http://www.excelforum.com/showthread...hreadid=521183