I have a table of data that is used to input a product metric every month.
Product names are in column [A], and number headings are in Row [1] (i.e.
1,2,3,4.....). We do not use month names. Metrics are then entered into each
row horizontally, for the list of products. Because of certain minimum
rules, not all products receive a metric every month, so each product has a
varied amount of metrics. To the right of these metrics, is a column that
performs a calculation on only the "last" entered metric for each product.
I'd like my formula in this far right column to be able to look to the left
and find the "last" entered metric. I'm stumped as to how to do this. Any
help would be greatly appreciated. Thank you....