Returning the last value in a column
Posted by Razzie3 on January 15, 2002 3:02 PM
I hope I haven't exceeded my limit of questions. I just found this board and have questions which no other knowledgeable folks have been able to answer. I hope some of you MS Excel Gurus can help me out. I attempting to make a table in the message but I don't know how it will turn out when published.
A B C D F G
1 1000 900 700 1200
2 200 800 1000
3 1200 1000 500 250 750
Is there a forumla that will look left from Column G and return the value of the fist cell that contains a value? In the example above I would want column G to end up having G1,1200 G2,1000 G3,750
I came up with a pretty complex method containing multiple IF and AND functions but I hope this is a better way.