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.
Friday, December 21, 2012
yogi_Formulate Entries In Cells B6 B7 And D7 From Entries Per User Specification
user mrodriguez712 said:(http://productforums.google.com/forum/?zx=vz0n90hy7lti#!mydiscussions/docs/ImLddhl-lFQ) if, then maybe lookup function (not sure) I have a vertical check in/out list in google spreadsheets. it consists of name (merge and center of 3 cells), date out, date supposed to be back (date out + 90 days), and date back in.
i want the top 2 rows to always display the person/dates associated with the lastest check in/out (HIGHLIGHTED YELLOW)
so i need it to display the latest (furthest down) name/date automatically, essentially look for the last (furthest down) cell with text and a date in it and display it in the top highlighted cells...