Last filled value in row
Posted by Svatopluk Vit on January 30, 2002 7:07 AM
I have sheet with products and prices for this products. It is price list. In the first column is product name, in the second column price from January, in third column price from February and so on. The price is filled only if changed. I have column (for example) W and there must be filled the last known price. The count of columns with prices is undefined. I can do that with macro. Is there any possibility to do this by using some "tricky" function(s)? Some special function like "Check last filled cell in a row"?
Thank you for your help.
Prague, Czech republic, Central Europe