title: Formula to pull cell from rightmost column with data (knowing row number)
body: <p>Is there a formula that I can use to pull a number from the rightmost column with data?  The row will never change and length of the column range is already predefined.  I will just be adding data in each column over time and would like the most recent number to appear in a separate cell.</p>
  
  <p>Thanks,</p>