With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Wednesday, February 6, 2013
yogi_From A List of Transactions Pull Most Recent Payment (Positive Amount) And The Associated Payment Date
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.