I have a spreadsheet that has a list of products and prices. The products are in column A and prices from C to whatever. The columns C-?? have prices each column a new date respectively. I need a formula that will report the furthest # to the right and show it in Column B. I also need the expandability to add columns for the latest pricing. I’m stuck on this one!!!!
Thanks in advanced
Matt
