Thank you so much....it works perfectly! Can I ask why "/(A2:Z2<"")" is
used in the formula?

"Rick Rothstein (MVP - VB)" wrote:

Whatever column you put your formula in, use the column before it for the
end of the row range. For example, if put your formula in AA, then use this
formula to get the contents of the last filled in cell before Column AA...

=LOOKUP(2,1/(A2:Z2<""),A2:Z2)

You can copy this formula down.

Rick


"Morton Detwyler" <Morton wrote in
message ...
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....