MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Last filled value in row


Posted by Svatopluk Vit on January 30, 2002 7:07 AM

Hello everybody,
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.

Svatopluk
Prague, Czech republic, Central Europe


Posted by Juan Pablo G. on January 30, 2002 7:11 AM

Try with

=INDEX(2:2,MATCH(9.99999E+307,2:2))

Juan Pablo G.