yogi_From A List of Transactions Pull Most Recent Payment (Positive Amount) And The Associated Payment Date

                                          Google Spreadsheet   Post  #1014

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 06, 2013

post by user: Ryan Magdaleno said:(http://productforums.google.com/forum/?zx=7mhl3dat7eu5#!category-topic/docs/spreadsheets/1r_Gk9FGdVg)

How to reference most recent positive value in a cloumn, and data from the same row in another column (spreadsheet newbie) 

I have a list of transactions (positive and negative) in a basic spreadsheet and I'd like to reference the last payment (positive value) and also corresponding date (different column, same row). In excel I was able to at least reference the last positive value using =LOOKUP(2,1/(Range>0),Range), but cant translate this to Google, or separately reference the corresponding date. I've attached a pic to explain better. 

Attachments (1)

Screen shot 2013-02-06 at 3.12.22 PM.png

35 KB   View   Download

------------------------------------

following is a solution