Wednesday, February 6, 2013

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    Feb 06, 2013
post by user: Ryan Magdaleno said:(!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