View Single Post
  #1   Report Post  
Carpie
 
Posts: n/a
Default Out of 12 cells in a row, I want farthest right

A1:A13 is January-December and Total. B1:B13 is the GOAL numbers. C1:C13
are the ACTUAL numbers. The numbers entered in the cells of row C are
aggregates (they include the amount of the previous months). I want C13 to
be the last number entered in that row (which will also be the last month in
which an actual was entered). Is there any formula that looks at those 12
cells and takes the farthest to the right?