Wednesday, April 3, 2013

yogi_Compute Row By Row The Latest Specified Entry In A Row And The Corresponding Date in The date Row

                                          Google Spreadsheet   Post  #1094
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Apr 3, 2013
user JFC1111 :(!mydiscussions/docs/Rt7EzAjLJIQ)
I have a row that represents every day of any given month counting billable days. I also track billing status changes with a 3 digit code. I would like to have the row searched and if a code is found then it is translated into a word, like "community" into its own column. I would also like to return the date the code was entered into another column.
Here is the link to the sheet.

following is a solution to the problem